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

[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

 

[Michel Walsh]

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

 

[GDL]

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