Cannot enter time in form

Z

zila

My form display this message
'
"A numeric field or number that is a larger tahn the field size setting
permit"

For detail in table;

Field name; time
Data type; Date/Time
Description: Enter time "in" and "out"
Format : Medium date (after that; change to long date and general date)
Input Mask; 00.00/00.00??;
Required: No
IME mode:No control
Index.Yes (Duplicate.ok)
IME Sentence Mode; None

Thank you.
 
W

Wayne-I-M

Hi Zila

I would suggest having a field for [TimeIn] and another field for [TimeOut]
with the input masks set to 00:00 >LL;0;_

AfterUpdate of [TimeOut] you could use a calculated control if you need the
results of time worked
 
W

Wayne-I-M

Set the format as Short Time

By doing this will NOT get rid of the seconds (and hour mins date etc) but
they will not be displayed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top