Avatar of Sandra Smith
Sandra Smith
Flag for United States of America asked on

Set date control when form opens

I have an Access 2003 form that when it opens, I want the text control, txtDate, to simply be the date of the End of the MOnth for the prior month.  However, whenever I try to pass in today date via the Date function, it keeps error indicating it is a null value.  Can a text field be initialized to a date usign the form open event?  

Sandra
Microsoft DevelopmentMicrosoft ApplicationsMicrosoft Access

Avatar of undefined
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

For example ...

DateSerial(Year(Date()),Month(Date()),0)
Returns 04-30-2012
Sandra Smith

ASKER
Thank you.  I simply never think of the DateSerial and it always seems to solve my issues.

Sandra
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Pretty handy ...
Your help has saved me hundreds of hours of internet surfing.
fblack61