Formatting Unbount Textbox Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Microsoft Office Professional 2003, Access product, at its latest
and greatest updates applied level. I have a legal form length Form Letter
with the following information on it.

Now on this day, (date), the above entitled cause comes on for hearing
before the undersigned Hearing Officer; the Licensee and all interested
parties having been given an opportunity to offer evidence and present
argument and upon consideration thereof the undersigned Hearing Officer finds:

Where I have (date), on the first line, I want to include a field from my
Access Table which is a date field. Problem is, that the data in this date
field is stored as 01/05/05, for January 05, 2005. AND the date format I
need to use is 5 January, 2005.

I was using:

= "Now on this day," & [HRG_DATE] & ", the above entitled cause comes on
for hearing before the undersigned Hearing Officer; the Licensee and all
interested parties having been given an opportunity to offer evidence and
present argument and upon consideration thereof the undersigned Hearing
Officer finds:"

as value in this unbound text box, the results printed as follows:

Now on this day, 01/05/05, the above entitled cause comes on for hearing
before the undersigned Hearing Officer; the Licensee and all interested
parties having been given an opportunity to offer evidence and present
argument and upon consideration thereof the undersigned Hearing Officer finds:

Can any one out here in Access Support determine what or how I should code
this to get the results I need of date in format 05 January, 2005.

Thanks in advance.
 
I'm using Microsoft Office Professional 2003, Access product, at its latest
and greatest updates applied level. I have a legal form length Form Letter
with the following information on it.

Now on this day, (date), the above entitled cause comes on for hearing
before the undersigned Hearing Officer; the Licensee and all interested
parties having been given an opportunity to offer evidence and present
argument and upon consideration thereof the undersigned Hearing Officer finds:

Where I have (date), on the first line, I want to include a field from my
Access Table which is a date field. Problem is, that the data in this date
field is stored as 01/05/05, for January 05, 2005. AND the date format I
need to use is 5 January, 2005.

I was using:

= "Now on this day," & [HRG_DATE] & ", the above entitled cause comes on
for hearing before the undersigned Hearing Officer; the Licensee and all
interested parties having been given an opportunity to offer evidence and
present argument and upon consideration thereof the undersigned Hearing
Officer finds:"

as value in this unbound text box, the results printed as follows:

Now on this day, 01/05/05, the above entitled cause comes on for hearing
before the undersigned Hearing Officer; the Licensee and all interested
parties having been given an opportunity to offer evidence and present
argument and upon consideration thereof the undersigned Hearing Officer finds:

Can any one out here in Access Support determine what or how I should code
this to get the results I need of date in format 05 January, 2005.

Thanks in advance.
Click to expand...

Format the date within the expression.
For the current date:
= "Now on this day, ( " & Format(date(),"dd mmmm, yyyy") & " ), the
above entitled ...etc."

For a Date field in the report's recordsource:
= "Now on this day, ( " & Format([HRG_DATE],"dd mmmm, yyyy") & " ),
the above entitled ...etc."
 
Robert, here is the simplest way.............

If you want it to look like 5 January, 2005 then:

="Now on this day, " & Format(Date(),"d mmmm"", ""yyyy") & ", the above
entitled cause comes on
for hearing before the undersigned Hearing Officer; the Licensee and all
interested parties having been given an opportunity to offer evidence and
present argument and upon consideration thereof the undersigned Hearing
Officer finds:"

if you want a leading zero of the day is less than 10(05 January, 2005 then:

="Now on this day, " & IIf(DatePart("d",Date())<10,"0" & Format(Date(),"d
mmmm"", ""yyyy"),Format(Date(),"d mmmm"", ""yyyy")) & ", the above entitled
cause comes on
for hearing before the undersigned Hearing Officer; the Licensee and all
interested parties having been given an opportunity to offer evidence and
present argument and upon consideration thereof the undersigned Hearing
Officer finds:"

HTH

Greg
 
FredG and Greg.
Using your code, (and defaulted system date qualifier of Date), the
folllowing code works great as follows:

= “ Now on this day, “ & Format(Date(),â€dd mmmmâ€â€,â€â€yyyy) & “, the above
entitled cause comes on for hearing before the undersigned Hearing Officer,
the Licensee and all interested parties being given an opportunity to offer
evidence and present argument and upon consideration thereof the undersigned
Hearing Officer finds:â€

GETS THE FOLLOWING RESULTS IF SYSTEM DATE WAS 01/03/05 OF

Now on this day, 03 January, 2005, the above entitled cause comes on for
hearing before the undersigned Hearing Officer, the Licensee and all
interested parties being given an opportunity to offer evidence and present
argument and upon consideration thereof the undersigned Hearing Officer
finds:â€

But what I need is my specific date field from a record, not necessarily the
current system date. My date field name is HRG_DATE, its stored value for
January 15, 2004 would be 01/15/04. I tried this in the code:

= “ Now on this day, “ & Format(HRG_DATE(),â€dd mmmmâ€â€,â€â€yyyy) & “, the
above entitled cause comes on for hearing before the undersigned Hearing
Officer, the Licensee and all interested parties being given an opportunity
to offer evidence and present argument and upon consideration thereof the
undersigned Hearing Officer finds:â€

GETS THE FOLLOWING RESULTS OF

#Name?

Is there any way that I can use this same logic and get my specific special
date in that field converted properly.

I have tried it using the same text data in the unbound text box, and using
the HRG_DATE value only in that line works fine, but the printed form prints
out as

Now on this day, 01/15/04, etc......

I need it to print as

Now on this day, 15 January, 2004 etc.....

Any further suggestions would be greatly appreciated.

Thanks,

Robert Nusz @ DPS



Greg said:
Robert, here is the simplest way.............

If you want it to look like 5 January, 2005 then:

="Now on this day, " & Format(Date(),"d mmmm"", ""yyyy") & ", the above
entitled cause comes on
for hearing before the undersigned Hearing Officer; the Licensee and all
interested parties having been given an opportunity to offer evidence and
present argument and upon consideration thereof the undersigned Hearing
Officer finds:"

if you want a leading zero of the day is less than 10(05 January, 2005 then:

="Now on this day, " & IIf(DatePart("d",Date())<10,"0" & Format(Date(),"d
mmmm"", ""yyyy"),Format(Date(),"d mmmm"", ""yyyy")) & ", the above entitled
cause comes on
for hearing before the undersigned Hearing Officer; the Licensee and all
interested parties having been given an opportunity to offer evidence and
present argument and upon consideration thereof the undersigned Hearing
Officer finds:"

HTH

Greg

Robert Nusz @ DPS said:
I'm using Microsoft Office Professional 2003, Access product, at its latest
and greatest updates applied level. I have a legal form length Form Letter
with the following information on it.

Now on this day, (date), the above entitled cause comes on for hearing
before the undersigned Hearing Officer; the Licensee and all interested
parties having been given an opportunity to offer evidence and present
argument and upon consideration thereof the undersigned Hearing Officer finds:

Where I have (date), on the first line, I want to include a field from my
Access Table which is a date field. Problem is, that the data in this date
field is stored as 01/05/05, for January 05, 2005. AND the date format I
need to use is 5 January, 2005.

I was using:

= "Now on this day," & [HRG_DATE] & ", the above entitled cause comes on
for hearing before the undersigned Hearing Officer; the Licensee and all
interested parties having been given an opportunity to offer evidence and
present argument and upon consideration thereof the undersigned Hearing
Officer finds:"

as value in this unbound text box, the results printed as follows:

Now on this day, 01/05/05, the above entitled cause comes on for hearing
before the undersigned Hearing Officer; the Licensee and all interested
parties having been given an opportunity to offer evidence and present
argument and upon consideration thereof the undersigned Hearing Officer finds:

Can any one out here in Access Support determine what or how I should code
this to get the results I need of date in format 05 January, 2005.

Thanks in advance.
Click to expand...
Click to expand...
 
Fredg.

Please foregive me, your second answer works great for my date field, I made
a mistake and left the () in the code, when used as coded in example #2m it
works great, as follows:

" Now on this day, " & Format([HRG_DATE],"dd mmmm"",""yyyy) &", the above
mentioned......"

prints as follows:

Now on this day, 15 January, 2004, the above mentioned....

You must how ever, make sure that the unbound text box has the CAN GROW
and the CAN SHRINK controls set to "Y" to allow for proper expansion of print
area on report.

Many thanks to both Fredg and Greg whom replied....

I've got a lot of faith in those of us who use this, hopefully, this example
will fit someone elses needs along the way as well.

Keep up the good support work.

Robert Nusz @ DPS

fredg said:
I'm using Microsoft Office Professional 2003, Access product, at its latest
and greatest updates applied level. I have a legal form length Form Letter
with the following information on it.

Now on this day, (date), the above entitled cause comes on for hearing
before the undersigned Hearing Officer; the Licensee and all interested
parties having been given an opportunity to offer evidence and present
argument and upon consideration thereof the undersigned Hearing Officer finds:

Where I have (date), on the first line, I want to include a field from my
Access Table which is a date field. Problem is, that the data in this date
field is stored as 01/05/05, for January 05, 2005. AND the date format I
need to use is 5 January, 2005.

I was using:

= "Now on this day," & [HRG_DATE] & ", the above entitled cause comes on
for hearing before the undersigned Hearing Officer; the Licensee and all
interested parties having been given an opportunity to offer evidence and
present argument and upon consideration thereof the undersigned Hearing
Officer finds:"

as value in this unbound text box, the results printed as follows:

Now on this day, 01/05/05, the above entitled cause comes on for hearing
before the undersigned Hearing Officer; the Licensee and all interested
parties having been given an opportunity to offer evidence and present
argument and upon consideration thereof the undersigned Hearing Officer finds:

Can any one out here in Access Support determine what or how I should code
this to get the results I need of date in format 05 January, 2005.

Thanks in advance.
Click to expand...

Format the date within the expression.
For the current date:
= "Now on this day, ( " & Format(date(),"dd mmmm, yyyy") & " ), the
above entitled ...etc."

For a Date field in the report's recordsource:
= "Now on this day, ( " & Format([HRG_DATE],"dd mmmm, yyyy") & " ),
the above entitled ...etc."
Click to expand...
 
Back
Top