Date/Time field expands on focus

[BoxTop]

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!!!

[DonRayner]

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.