Change Data Enty back to NO and try inserting this into the Event Procedure in the OnLoad Property of the form:
DoCmd.GoToRecord , , acLast
This ought to work.
J Ahmed
You can use conditional formatting to change the colour of the fill, text or the font itself when the data in the field satisfies certain conditions. Simply click on Format in the menu toolbar (In design view), Conditional Formatting and select you conditions and format changes...
I may have find a simple solution to your problem.
I just gave the following a try and I think it does what you want it to do:
Set the Input mask to: 00/00/00## and the format to long date (Note this will show 10 february 2002)
When inputting the date only 4 digits need to be entered the last...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.