Default Value for a Date field

[rlf1957]

Trying to use the 'Date()' function as a default value for a date field in an "Orders" table.

Getting Invalid function. This worked in a similar db I created in Access97, now that we have converted to Access2003 the "Invalid" msg comes up.

Any ideas would be appreciated.
Thanks,

RickF

 

[traingamer]

Either Now() or Date() worked for me as a default. Do you have an Input Mask defined for that field?

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[PHV]

Check your references:
when in VBE (Alt+F11) menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[rlf1957]

traingamer - NOw() worked but DATE() doesn't. No input mask defined.

phv - can you explain further the references and what I should be looking for.

Thanks,

RF

 

[PHV]

NOw() worked but DATE() doesn't
OK, so no references issue.
You may try VBA.Date()
Perhaps you have a field/control named date ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244