Date function not working

[Greyowlsl]

Hi,

I have a form that has text box called 'date1', i then have a button called 'todays_date' which on click does 'me.date1 = date' however no date is entered. If i do 'me.date1.setfocus' it gets focus, so why dosent date work? are there any text box properties that could affect this? It works fine if you just type the date in.

Thanks for your time and help.
Greyowl.

 

[John Big Booty]

Are you getting any sort of error message?

 

[missinglinq]

When a common Function like Date() doesn't work you have to think about Missing References. Although I've never personally seen it, there are reports, from reliable developers, saying that having a Missing Reference can cause Functions not to work, even when the Function in question isn't in the Reference that is missing!

If you haven't checked for this kind of thing before, here are Doug Steele's detailed instructions on how to troubleshoot the problem:

http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html

Linq ;0)>