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?
Microsoft DevelopmentMicrosoft ApplicationsMicrosoft Access
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)