Time and Date field taking up too much room

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

How can I split the Date and Time Field for data entry? I have it storing
both in the table but it doesn't fit well on my form. Can I make 2
textboxes bound to this field and label one Date and the other Time? Using
Access 2003

Thanks,
Linda
 
Linda

What you store (in a table/field) and what you display in a form do not have
to be the same.

If you want, in a form, to display only the date portion of a date/time
field, you can use the format property to only show that much. You can do
something similar for the time portion.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
There is a bit of a problem here, Jeff. Regardless of the fact that creating
two controls would, I think, take up more room than one control, only one
control can be bound the the field. Certainly, portions of it can be
displayed in multiple fields; however, editing will be a challenge. It would
take some careful coding to recombine the two to get the desired result.

I would recommend the OP abandon this idea.
 
I do need to store both because I am going to calculate total hours based on
StDtTm and EndDtTm. I could just design my form differently so it will fit
better but I still have the problem of ease of data entry. I have been
playing around with using a mask vs not using a mask and nothing seems to be
easy. I have done some date calculations with months, quarters and years
(but don't fully understand even these yet) but never anything to figure
out hours before. Easy is best for me at this point.

Linda
 
I originally had a start date and start time field. It was suggested to use
only one field since access stores both. I am trying to do that but not
having too much luck. Data entry seems difficult with both in one field
especially with the number of Date and Times I need to have in this
database.

Linda
 
Input masks are a pain. I would suggest you use the General Date Format (not
an imput mask, the Format property for the control).

With a little training, data entry becomes pretty easy. All you need to do
is enter the date using / as the delimiter, once space after the date, use
the period to separate hours and minutes. If you skip seconds, they will
fill with 0.
If want AM, it is the default. If you want PM, just type P after the last
time entry (no space required) and it fills in or you can use a 24 hour entry
and it will convert it for you, so if you typed 9/20/06 14.0<Enter> it would
convert to
9/20/2006 2:00:00 PM
 
Thanks. That is pretty easy. I guess I'll make a little "cheat sheet"
card and these instructions will be the first.

Linda
 
Good idea. The users will get used to it with a little practice. Once they
get it down, they will like it better than dealing with two fields and it
will make your life easier (but you don't have to tell the users that)
 
Back
Top