By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,869 Members | 1,560 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,869 IT Pros & Developers. It's quick & easy.

Date/Time field expands on focus

P: 12
Here is an Access 97 problem that's been bugging me for years. On a form I set up a date/time field. I set up the format to be dd/MM/yy hh:nn. I set the input mask to be ##/##/##\ ##:##;0;_

All is fine when you first enter data into the control. If you then put the cursor back into the control the data in the field expands to include seconds instead of just the date, hours and minutes. This compltely blows the input mask so that if you then try to change something like the day for example, you get an error saying "The value you entered isn't valid for the input mask". Well, of course it isn't valid because Access is displaying seconds when the format says it shouldn't. AAAGGGHHHH!!!
Sep 19 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 489
It doesn't matter how you format the field on your form. When you click on it to edit it will display in the format set in the underlying table. If you want a certain format throughout your project make sure to format the date/time field in the table the same way from the start.
Sep 23 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.