Memo Field in a report containing fields from a form

  • Thread starter Thread starter ZOYA
  • Start date Start date
Z

ZOYA

This is what I have: ( I have each "section" of text as seperate text fields
in order to plug in the [field name]) in between the text.)

Basis: On [First Notice Date] the owner was given notice to remove
rubbish from the property. On [Follow up Date] city went to residence and
removed the rubbish at a cost of [fee]. City invoiced owner on [invoice
date]. Owner failed to pay the invoice within 30 days.

My question. The fields fill in with the info from the form just fine, but
the spacing is all screwed up, especially if the date is May instead of
September; then there's a huge blank space after the date. It's accurate,
but it looks dumb. Can anyone help me with this?

Thanks
 
ZOYA said:
This is what I have: ( I have each "section" of text as seperate text fields
in order to plug in the [field name]) in between the text.)

Basis: On [First Notice Date] the owner was given notice to remove
rubbish from the property. On [Follow up Date] city went to residence and
removed the rubbish at a cost of [fee]. City invoiced owner on [invoice
date]. Owner failed to pay the invoice within 30 days.

My question. The fields fill in with the info from the form just fine, but
the spacing is all screwed up, especially if the date is May instead of
September; then there's a huge blank space after the date. It's accurate,
but it looks dumb.
Click to expand...


Use a single text box and concatenate the "sections" in its
expression:

="On " & [First Notice Date] & " the owner was ..." & ...
 
OK - that worked beautifully - but now the date is coming out 06/23/2008
instead of June 23, 2008. I changed the date format to long date in the
table, query, field properties in the form and on the report, and on my
system. Still happens. What did I miss?

Marshall Barton said:
ZOYA said:
This is what I have: ( I have each "section" of text as seperate text fields
in order to plug in the [field name]) in between the text.)

Basis: On [First Notice Date] the owner was given notice to remove
rubbish from the property. On [Follow up Date] city went to residence and
removed the rubbish at a cost of [fee]. City invoiced owner on [invoice
date]. Owner failed to pay the invoice within 30 days.

My question. The fields fill in with the info from the form just fine, but
the spacing is all screwed up, especially if the date is May instead of
September; then there's a huge blank space after the date. It's accurate,
but it looks dumb.
Click to expand...


Use a single text box and concatenate the "sections" in its
expression:

="On " & [First Notice Date] & " the owner was ..." & ...
Click to expand...
 
The Format property is applied to the result of the
expression, not to various values in the expression. To get
what you want use the Format function in the expression:

="On " & Format([First Notice Date], "mmmm dd, yyyy") & "
the owner was ..." & ...
--
Marsh
MVP [MS Access]

OK - that worked beautifully - but now the date is coming out 06/23/2008
instead of June 23, 2008. I changed the date format to long date in the
table, query, field properties in the form and on the report, and on my
system.

Marshall Barton said:
Use a single text box and concatenate the "sections" in its
expression:

="On " & [First Notice Date] & " the owner was ..." & ...
Click to expand...
Click to expand...
 
Back
Top