Default Value = Last day of the Current Month

[Kay]

Any Ideas?

Thanks in advance.

 

[Kay]

Sorry, I see that the subject cut off the last word.

Default Value = Last day of the current month.

 

[boblarson]

=DateSerial(Year(Date()), Month(Date())+1, 0)
--

Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP
Free Access Resources at http://www.btabdevelopment.com

 

[fredg]

Any Ideas?

Thanks in advance.

Answered elsewhere.
Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), crosspost by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.

 

[Kay]

Thank you for your help Bob.

Sorry for the inconvenience fredg.

 

[Kay]

I went to the website you suggested. I read Netiquette thoroughly. I am not
a stranger to computers but I am to the world of newsgroups. Several things
were unfamiliar to me. Thank You I would not want to offend anyone since
I could not have built my database without this site.

See Netiquette at http://www.mvps.org/access