Date/Time Formatting

[Mike S. S.]

I have a date/time field that I need to display on a form in 24hr time: e.g.,
12/3/2008 23:04, which is 11:04 PM. This is the equivalent of a short date
AND a short time. However, it does not seem like any of the selectable
formats in the drop-down of a textbox on a form which is displaying this
date/time field give me what I want.

SO, what is the best/easiest way to deal with displaying date/time data in
the way I need to? I would greatly appreciate ANY help from someone who has
dealt with this problem and either has figured out a solution on their own or
has the "Microsoft-sanctioned" solution.

Michael

 

[Ken Sheridan]

Michael:

You can format the date/time value however you wish by entering the
relevant string expression a the field's Format property, in your case:

mm/d/yyyy hh:nn

Ken Sheridan
Stafford, England

 

[Mike S. S.]

Ken, can you answer another question? Have a form with 2 subforms. When I
make a copy of the form and set it's Default View to Datasheet, I only get
one '+' in the first col which allows me to data enter into one of the
subforms. The 2nd subform is no where to be seen. Is this a limit of Access
2003? Or do I need to do something "special", which I didn't to get it to
work giving me the one '+'?? Thanks, (e-mail address removed)

 

[Mike S. S.]

Michael:

You can format the date/time value however you wish by entering the
relevant string expression a the field's Format property, in your case:

mm/d/yyyy hh:nn

Ken Sheridan
Stafford, England


Ken, can you answer another question? Have a form with 2 subforms. When I make a copy of the form and set it's Default View to Datasheet, I only get one '+' in the first col which allows me to data enter into one of the subforms. The 2nd subform is no where to be seen. Is this a limit of Access 2003? Or do I need to do something "special", which I didn't to get it to work giving me the one '+'?? Thanks, (e-mail address removed)

 

[Ken Sheridan]

Michael:

To be honest I'm not very familiar with the way sub-datasheets work as they
are not something I'd use myself. I would always create forms for use as
subforms and embed these in a parent form. Also I always use continuous form
view rather than datasheet view for a tabular layout. From playing around
with a table with two tables in a many-to-one relationship to it, however, it
does appear that only one sub-datasheet at a time is possible. I could be
wrong, but as I said its not a feature of Access I'm all that familiar with.

When using true subforms it’s a simple task to embed two in a parent form
which is in single form view. With a parent form in continuous from view,
however, it’s a little trickier as you have to correlate the parent from and
the subforms via a hidden control as a 'middleman'.

BTW I'd advise against posting your email address here unless you mung it,
e.g. mschles4695<at>yahoo<dot>com. You could well find it harvested by
spammers otherwise.

Ken Sheridan
Stafford, England