="tekst" +[Date1] + "other tekst" --------problem #fout

  • Thread starter Thread starter GDL
  • Start date Start date
G

GDL

If I use this
="tekst" +[Date1] + "other tekst"
in a Report i receive this #error
when I do
=[Date1]
this is correct

how can I display dates and text together ?

one other question : is it possible to change the color for the date also ?

regards,
Geert
 
Hi,


Your control has the name [Date1]. When you use =[Date1], it is obvious you
refer to the FIELD, when you use
="tekst" +[Date1] + "other tekst" , Access infers you refer to the control,
which is itself, which creates an infinite loop. Changing the name of the
control, in the report, should solve the problem.



Hoping it may help,
Vanderghast, Access MVP


If I use this
="tekst" +[Date1] + "other tekst"
in a Report i receive this #error
when I do
=[Date1]
this is correct

how can I display dates and text together ?

one other question : is it possible to change the color for the date also ?

regards,
Geert
 
use "tekst" & [date1]
don't use the + sign, use the & sign
"GDL" <[email protected]> schreef in bericht If I use this
="tekst" +[Date1] + "other tekst"
in a Report i receive this #error
when I do
=[Date1]
this is correct

how can I display dates and text together ?

one other question : is it possible to change the color for the date also ?

regards,
Geert
 
Back
Top