Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Default Date Returns a -1 instead of month

Status
Not open for further replies.

edowling

Technical User
Nov 17, 2000
12
US
I have a field on a form that I have set the default value to enter the current month. The string I used to do this is:

=Format(Now(),"mmmm")

When I open the form, the month does not show up in the correct format. Instead, it displays -1

Any ideas on how to fix this?

Thanks,

Lis
 
Try creating an empty test form and create a text box on it. Set the default value to your expression and try it. Then, compare the two controls from the one that is having trouble with the test version.

I tried to reproduce your problem, but it worked fine for me. So, there is obviously something else wrong.

Hope that helps,
Gary
gwinn7
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top