ODBiC Discussion Board

UPDATEFORM: how to use formatting when displaying the values of fields

by Ilona Morison
July 9, 2002 11:24

I am using a UPDATEFORM to check with the user before that information is correct in the database. I am using a date/time field in Access and when displayed in the UPDATEFORM it is displaying the full date/time: eg if I have entered 16:00 in the screen form, I get displayed '1899-12-30 16:00:00'. I have tried usinf the $mid or $right functions but it does not work. Is there a way of filtering this info to display only the correct time (as far as the user in concerned).


Post Your Reply:

E-mail  optional

HTTP Link: 
Link text: 

Copyright ©1997, Roger Harris. All rights reserved.