Combining text and a date value as a default value on a text box

shelds

New member
Local time
Today, 23:16
Joined
Mar 6, 2007
Messages
9
This may be a really simple but just can't figure it out. In the default value in a text box on a form I would like it to say "Checks Completed on" =date() but all it returns is a 0. If using the date function on its own it comes back with the date fine in the field.

Any Ideas how I comine text and a expression as a default value, when in design view in a form? :)
 
Try

="your text here" & Date()
 
Thanks alot, I think I had tried about every other combination! :D
 

Users who are viewing this thread

Back
Top Bottom