Long date and long time

  • Thread starter Thread starter Steve Wright
  • Start date Start date
S

Steve Wright

Hi all,

Anyone know how to format a long date with a long time after it as a single
report field?

I want it to read "Thursday, 19 February 2004 15:33:25"

TIA
Steve
 
Are they in separate fields? If yes, use this in the control source of the
control:

=[LongDateFieldName] & " " & [LongTimeFieldName]
 
Ken,

Ive tried "Now() & " " Now()" but the formating under properties only lets
me have one format!

Steve


Ken Snell said:
Are they in separate fields? If yes, use this in the control source of the
control:

=[LongDateFieldName] & " " & [LongTimeFieldName]

--
Ken Snell
<MS ACCESS MVP>

Steve Wright said:
Hi all,

Anyone know how to format a long date with a long time after it as a single
report field?

I want it to read "Thursday, 19 February 2004 15:33:25"

TIA
Steve
Click to expand...
Click to expand...
 
Ken

=Format(Now(),"dddd\," & " " & "d mmmm yyyy HH:mm:ss")

seems to work
Steve Wright said:
Ken,

Ive tried "Now() & " " Now()" but the formating under properties only lets
me have one format!

Steve


Ken Snell said:
Are they in separate fields? If yes, use this in the control source of the
control:

=[LongDateFieldName] & " " & [LongTimeFieldName]

--
Ken Snell
<MS ACCESS MVP>

Steve Wright said:
Hi all,

Anyone know how to format a long date with a long time after it as a single
report field?

I want it to read "Thursday, 19 February 2004 15:33:25"

TIA
Steve
Click to expand...
Click to expand...
Click to expand...
 
Yes, using Format is the correct option. I hadn't included that in my first
reply because I understood that you were wanting to combine two fields that
were formatted already with the long date and long time.

Good luck.

--
Ken Snell
<MS ACCESS MVP>

Steve Wright said:
Ken

=Format(Now(),"dddd\," & " " & "d mmmm yyyy HH:mm:ss")

seems to work
Steve Wright said:
Ken,

Ive tried "Now() & " " Now()" but the formating under properties only lets
me have one format!

Steve


Ken Snell said:
Are they in separate fields? If yes, use this in the control source of the
control:

=[LongDateFieldName] & " " & [LongTimeFieldName]

--
Ken Snell
<MS ACCESS MVP>

Hi all,

Anyone know how to format a long date with a long time after it as a
single
report field?

I want it to read "Thursday, 19 February 2004 15:33:25"

TIA
Steve
Click to expand...
Click to expand...
Click to expand...
 
Back
Top