General information
Category:
Forms & Form designer
Greetings all,
My appologize if my question sounds stupid one, but I really need your help about this one.
I have a time field that is a character type. I defined it in the table with 11 bytes character length (like hh:mm:ssA.M or P.M). On my form, I have a text box display the time that the user enters or clicks on the current time button. My problem is I don't know how just display the time in 12 hours with time format is A.M or P.M. For example, the textbox should show up 1:25:45P.M in stead of 13:25:45.
I tried to use an unput mask of 99:99:99A with R in the formatt property then put something int the KeyPress even of the textbox as following:
****************
LPARAMETERS nKeyCode, nShiftAltCtrl
If not inlist(nKeyCode, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 97, 112, 65, 80)
nodefault
endif
****************
However, it didn't work like what I want.
I would appreciate any ideas, suggestions from the experts.
Thanks,
Jenny.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only