Date() not found in Access designer

[Dmitry Perets]

Hello,

I have a strange problem with Microsoft Access 2000. I have a form with a date field. When I try to set the default value for that field (from the designer) to "=Date()", it tells me that the use of this function is illegal in that place. But if I use the same function Date() from the VBA code, everything is fine, so it do "knows" this function...

Where can be the problem?

 

[Dennisk]

are you surrounding the =Date() in quotes, if so that is your problem.

 

[Dmitry Perets]

are you surrounding the =Date() in quotes, if so that is your problem.

No, there is no quotes there... Any other ideas?

 

[neileg]

Sounds ike a reference problem.

 

[Dmitry Perets]

Sounds ike a reference problem.

Is there any place to specify references for DESIGNER? Because in VB's references everything is fine, I suppose... I CAN access the Date() function from VB's code...

 

[MStef]

Open any VBA code, (form or module), click on TOOLS, REFERENCES,
if you find any MISSING references, deselect it.

 

[Dmitry Perets]

Open any VBA code, (form or module), click on TOOLS, REFERENCES,
if you find any MISSING references, deselect it.

As I said, everything is OK in VB's references... Nothing is missing there.

 

[boblarson]

As I said, everything is OK in VB's references... Nothing is missing there.

The date one sometimes doesn't show as missing, but still is.

See my answer in this post:
http://www.access-programmers.co.uk/forums/showthread.php?t=115185&highlight=missing+reference