Long date and long time

[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

 

[Ken Snell]

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

=[LongDateFieldName] & " " & [LongTimeFieldName]

 

[Steve Wright]

Ken,

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

Steve

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

 

[Steve Wright]

Ken

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

seems to work

Ken,

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

Steve

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

 

[Ken Snell]

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>

Ken

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

seems to work

Ken,

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

Steve

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