Inputting Time

[parls]

I am creating a time sheet database based on excel spreadsheets. The user is
used to entering start times and end times in a military format without
colons. For example: he enters start time as 630 and the data is converted to
6:30 am in another cell. I want to duplicate this action in access. I can't
figure out how.

Thanks,
parls

 

[Tom van Stiphout]

On Tue, 2 Mar 2010 08:25:01 -0800, parls

Perhaps you could have a second textbox and set the controlsource to:
=Left$(myTextbox,2) & ":" & Right$(myTextbox,2)
(of course you replace myObjectNames with yours)

-Tom.
Microsoft Access MVP

 

[De Jager]

I am creating a time sheet database based on excel spreadsheets. The user
is
used to entering start times and end times in a military format without
colons. For example: he enters start time as 630 and the data is converted
to
6:30 am in another cell. I want to duplicate this action in access. I
can't
figure out how.

Thanks,
parls