Some TextBox contents don't print

[LongWayFromHome]

Certain of my report TextBoxes appear in the screen preview but their
contents disappear on the printout. (The boxes themselves appear on the
printout.)

This TextBox works fine:
=FormatCurrency(DLookUp("SumMVLFYMktVal","RptStats04Qry"),0)

But this date loses its content in the printout (SWB is the calling form):
=Format([Forms]![SWB].[MailDate],"mmmm d"", ""yyyy")

Can anyone help me on this? If it matters, the error affects only dates.

Thanks!

 

[Allen Browne]

If the text characters do print except of the digits, do you have the French
language on your computer?

There was a bug some years ago (Access 2000, I think), and the solution
involved making sure the Arabic font was installed.

Sorry that's rather hazy: I can't find the link. If you don't use French,
this is not the solution you need.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[LongWayFromHome]

No, I don't use French, though I am using 2000. In any case, nothing in the
txtbox prints, which includes the date spelled out.

On the theory that somehow the report loses the references to the calling
form ([Forms]![SWB].[MailDate]) when it prints, I am going to try to assign
the value to an unbound txtbx from inside [SWB]. I'll let everybody know if
it works.
--
Dave

If the text characters do print except of the digits, do you have the French
language on your computer?

There was a bug some years ago (Access 2000, I think), and the solution
involved making sure the Arabic font was installed.

Sorry that's rather hazy: I can't find the link. If you don't use French,
this is not the solution you need.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message

Certain of my report TextBoxes appear in the screen preview but their
contents disappear on the printout. (The boxes themselves appear on the
printout.)

This TextBox works fine:
=FormatCurrency(DLookUp("SumMVLFYMktVal","RptStats04Qry"),0)

But this date loses its content in the printout (SWB is the calling form):
=Format([Forms]![SWB].[MailDate],"mmmm d"", ""yyyy")

Can anyone help me on this? If it matters, the error affects only dates.

Thanks!

 

[Allen Browne]

Ah, the report is reading the date from the form?
Is the form still open?

If the MailDate text box on the form is not bound to a date/time field, set
its Format property to Short Date or similar to ensure Access understands
it.

If the text box is bound to a date/time field and the form is still open,
you just need to make sure that the current record of the form contains the
date you wish to see in your report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message

No, I don't use French, though I am using 2000. In any case, nothing in
the
txtbox prints, which includes the date spelled out.

On the theory that somehow the report loses the references to the calling
form ([Forms]![SWB].[MailDate]) when it prints, I am going to try to
assign
the value to an unbound txtbx from inside [SWB]. I'll let everybody know
if
it works.
--
Dave

If the text characters do print except of the digits, do you have the
French
language on your computer?

There was a bug some years ago (Access 2000, I think), and the solution
involved making sure the Arabic font was installed.

Sorry that's rather hazy: I can't find the link. If you don't use French,
this is not the solution you need.

message

Certain of my report TextBoxes appear in the screen preview but their
contents disappear on the printout. (The boxes themselves appear on
the
printout.)

This TextBox works fine:
=FormatCurrency(DLookUp("SumMVLFYMktVal","RptStats04Qry"),0)

But this date loses its content in the printout (SWB is the calling
form):
=Format([Forms]![SWB].[MailDate],"mmmm d"", ""yyyy")

Can anyone help me on this? If it matters, the error affects only
dates.

 

[LongWayFromHome]

Yes, the problem does seem to be that, when the report formats, it can't
"see" SWB.MailDate. The form field is a fill-in for the user, and it is
formatted as a General Date, so there is no connection to a record. (FYI,
this particular date appears in a cover memo that tells the recipient "Get
your stuff to me by [MailDate - 21] or I send over Elroy."

Meanwhile, I did finally devise a method: declare a date variable in
Module:Utility, load it up with the MailDate in SWB, and then define the
report's unbound textbox in the format event.

Wow.
--
Dave

Ah, the report is reading the date from the form?
Is the form still open?

If the MailDate text box on the form is not bound to a date/time field, set
its Format property to Short Date or similar to ensure Access understands
it.

If the text box is bound to a date/time field and the form is still open,
you just need to make sure that the current record of the form contains the
date you wish to see in your report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message

No, I don't use French, though I am using 2000. In any case, nothing in
the
txtbox prints, which includes the date spelled out.

On the theory that somehow the report loses the references to the calling
form ([Forms]![SWB].[MailDate]) when it prints, I am going to try to
assign
the value to an unbound txtbx from inside [SWB]. I'll let everybody know
if
it works.
--
Dave

If the text characters do print except of the digits, do you have the
French
language on your computer?

There was a bug some years ago (Access 2000, I think), and the solution
involved making sure the Arabic font was installed.

Sorry that's rather hazy: I can't find the link. If you don't use French,
this is not the solution you need.

message
Certain of my report TextBoxes appear in the screen preview but their
contents disappear on the printout. (The boxes themselves appear on
the
printout.)

This TextBox works fine:
=FormatCurrency(DLookUp("SumMVLFYMktVal","RptStats04Qry"),0)

But this date loses its content in the printout (SWB is the calling
form):
=Format([Forms]![SWB].[MailDate],"mmmm d"", ""yyyy")

Can anyone help me on this? If it matters, the error affects only
dates.