Date issues

B

blendes

I am working on a database that has me using both Access 2003 and access 2007
because the computer i have has 2003 and the computers running it have 2007.
I put the date function in my form so the users can just click it to add the
date to the operations they are working on. In 2003 the button works fine and
the field shows the correct date. In 2007, the field shows #### but when you
click on the field the date shows up and then goes away when you click away.
The Button is putting in the date but access 2007 is not showing the date.
 
L

Linq Adams via AccessMonster.com

I'm not sure but 2007, by default I think, shows numbers as #### if
column/textbox is too narrow to display the entire value. Since dates are
actually stored numbers, this may be what is happening. According to Allen
Browne this default can be changed:

Office Button | Access Options | Current Database | Check for truncated
number fields.
 
Top