Static Data Field/Memo without link to table

[Jenny B.]

Hi All,

I’m a bit green to the Access Report usage, so please bear with me in the
event you’ve answered this question multiple times (didn’t see an entry quite
like this).

I have a Report I’m constructing that pulls fields from the preformatted
Entry Form. In addition to the data fields, I also want to add a large block
of static text that will always be the same minus the merge fields (see the
example below). I’ve been able to do this successfully without linking to a
table, but I’m only allowed a certain number of characters. Since I’m not
linking to a table, I’m stuck and don’t know how to change it over to a Memo
(seems to make me select text without a link).

Any thoughts on how I can achieve the below, but create a much longer letter?

Thanks – Jenny B.


="In reference to your visit on " & Format([DateLastVisit],"mm/dd/yy") & "
with " & [Physician] & ", your " & [TestType] " & came back with " &
[TestResult] & ". We have scheduled a followup visit on " &
Format([DateNextVisit],"mm/dd/yy") & "."

 

[Jeff Boyce]

Jenny

A couple clarifications...

Access tables store data, Access forms display it (on screen), and Access
reports are used to format data for display in printed format.

Your report probably isn't "pulling fields" from a form, but it might be
that you told Access to "print" the "form". Do you have a report in the
reports tab (database window) that you can edit?

Reports generally rely on data from tables (or from queries based on those
tables). The exception is when you add a control to a report to display
"static" text.

Does any of this help explain what you're seeing?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[brlubman]

Jenny

A couple clarifications...

Access tables store data, Access forms display it (on screen), and Access
reports are used to format data for display in printed format.

Your report probably isn't "pulling fields" from a form, but it might be
that you told Access to "print" the "form". Do you have a report in the
reports tab (database window) that you can edit?

Reports generally rely on data from tables (or from queries based on those
tables). The exception is when you add a control to a report to display
"static" text.

Does any of this help explain what you're seeing?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi All,

I'm a bit green to the Access Report usage, so please bear with me in the
event you've answered this question multiple times (didn't see an entry
quite
like this).

I have a Report I'm constructing that pulls fields from the preformatted
Entry Form. In addition to the data fields, I also want to add a large
block
of static text that will always be the same minus the merge fields (see
the
example below). I've been able to do this successfully without linking to
a
table, but I'm only allowed a certain number of characters. Since I'm not
linking to a table, I'm stuck and don't know how to change it over to a
Memo
(seems to make me select text without a link).

Any thoughts on how I can achieve the below, but create a much longer
letter?

Thanks - Jenny B.


="In reference to your visit on " & Format([DateLastVisit],"mm/dd/yy") & "
with " & [Physician] & ", your " & [TestType] " & came back with " &
[TestResult] & ". We have scheduled a followup visit on " &
Format([DateNextVisit],"mm/dd/yy") & "."

 

[Jenny B.]

Hi Jeff,

I meant an Entry Form that adds data to a Table which has been further
modified by a Query. The Report I’m editing uses certain fields that come
from the Query that’s generated by the entries from the fore mentioned Entry
Form. In my particular case, I want the Report to include a block of text
and include merge fields much like my last example. The only problem is since
this field does not have a Control Source selected from that Query (doesn’t
need to be since its just static text), it will not allow me to set the field
as a Memo. Without it being a memo, I’m limited to only a certain amount of
characters and that's far short of the amount I need.

Any thoughts on what I can do?

Thanks again– Jenny B.

Jenny

A couple clarifications...

Access tables store data, Access forms display it (on screen), and Access
reports are used to format data for display in printed format.

Your report probably isn't "pulling fields" from a form, but it might be
that you told Access to "print" the "form". Do you have a report in the
reports tab (database window) that you can edit?

Reports generally rely on data from tables (or from queries based on those
tables). The exception is when you add a control to a report to display
"static" text.

Does any of this help explain what you're seeing?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi All,

I'm a bit green to the Access Report usage, so please bear with me in the
event you've answered this question multiple times (didn't see an entry
quite
like this).

I have a Report I'm constructing that pulls fields from the preformatted
Entry Form. In addition to the data fields, I also want to add a large
block
of static text that will always be the same minus the merge fields (see
the
example below). I've been able to do this successfully without linking to
a
table, but I'm only allowed a certain number of characters. Since I'm not
linking to a table, I'm stuck and don't know how to change it over to a
Memo
(seems to make me select text without a link).

Any thoughts on how I can achieve the below, but create a much longer
letter?

Thanks - Jenny B.


="In reference to your visit on " & Format([DateLastVisit],"mm/dd/yy") & "
with " & [Physician] & ", your " & [TestType] " & came back with " &
[TestResult] & ". We have scheduled a followup visit on " &
Format([DateNextVisit],"mm/dd/yy") & "."

 

[Jeff Boyce]

Jenny

Probably there's a more 'elegant' solution, but here's a kludge that could
get the job done.

Use more than one text control. Add as much text to each as it will hold.
Position them close to each other.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi Jeff,

I meant an Entry Form that adds data to a Table which has been further
modified by a Query. The Report I'm editing uses certain fields that come
from the Query that's generated by the entries from the fore mentioned
Entry
Form. In my particular case, I want the Report to include a block of text
and include merge fields much like my last example. The only problem is
since
this field does not have a Control Source selected from that Query (doesn't
need to be since its just static text), it will not allow me to set the
field
as a Memo. Without it being a memo, I'm limited to only a certain amount
of
characters and that's far short of the amount I need.

Any thoughts on what I can do?

Thanks again- Jenny B.

Jenny

A couple clarifications...

Access tables store data, Access forms display it (on screen), and Access
reports are used to format data for display in printed format.

Your report probably isn't "pulling fields" from a form, but it might be
that you told Access to "print" the "form". Do you have a report in the
reports tab (database window) that you can edit?

Reports generally rely on data from tables (or from queries based on
those
tables). The exception is when you add a control to a report to display
"static" text.

Does any of this help explain what you're seeing?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi All,

I'm a bit green to the Access Report usage, so please bear with me in
the
event you've answered this question multiple times (didn't see an entry
quite
like this).

I have a Report I'm constructing that pulls fields from the
preformatted
Entry Form. In addition to the data fields, I also want to add a large
block
of static text that will always be the same minus the merge fields (see
the
example below). I've been able to do this successfully without linking
to
a
table, but I'm only allowed a certain number of characters. Since I'm
not
linking to a table, I'm stuck and don't know how to change it over to a
Memo
(seems to make me select text without a link).

Any thoughts on how I can achieve the below, but create a much longer
letter?

Thanks - Jenny B.


="In reference to your visit on " & Format([DateLastVisit],"mm/dd/yy")
& "
with " & [Physician] & ", your " & [TestType] " & came back with " &
[TestResult] & ". We have scheduled a followup visit on " &
Format([DateNextVisit],"mm/dd/yy") & "."

 

[Jenny B.]

Hi Again,

I came up with that one too and I'm trying to avoid it if all possible. I’m
in luck though because I stumbled upon something that might actually fit the
bill. I have a book “Access VBA Programming Third Edition†with an example
that programmatically calls a large block of text to an unbound txt filed.
That appears to work and I think I can additional set marked values in the
Table Fields that I can call out letter with a routine to merge in the needed
text (hopefully).

Thank you so much for your review and I appreciate you taking the time to
answer back.

Take care – Jenny B.

Jenny

Probably there's a more 'elegant' solution, but here's a kludge that could
get the job done.

Use more than one text control. Add as much text to each as it will hold.
Position them close to each other.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi Jeff,

I meant an Entry Form that adds data to a Table which has been further
modified by a Query. The Report I'm editing uses certain fields that come
from the Query that's generated by the entries from the fore mentioned
Entry
Form. In my particular case, I want the Report to include a block of text
and include merge fields much like my last example. The only problem is
since
this field does not have a Control Source selected from that Query (doesn't
need to be since its just static text), it will not allow me to set the
field
as a Memo. Without it being a memo, I'm limited to only a certain amount
of
characters and that's far short of the amount I need.

Any thoughts on what I can do?

Thanks again- Jenny B.

Jenny

A couple clarifications...

Access tables store data, Access forms display it (on screen), and Access
reports are used to format data for display in printed format.

Your report probably isn't "pulling fields" from a form, but it might be
that you told Access to "print" the "form". Do you have a report in the
reports tab (database window) that you can edit?

Reports generally rely on data from tables (or from queries based on
those
tables). The exception is when you add a control to a report to display
"static" text.

Does any of this help explain what you're seeing?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi All,

I'm a bit green to the Access Report usage, so please bear with me in
the
event you've answered this question multiple times (didn't see an entry
quite
like this).

I have a Report I'm constructing that pulls fields from the
preformatted
Entry Form. In addition to the data fields, I also want to add a large
block
of static text that will always be the same minus the merge fields (see
the
example below). I've been able to do this successfully without linking
to
a
table, but I'm only allowed a certain number of characters. Since I'm
not
linking to a table, I'm stuck and don't know how to change it over to a
Memo
(seems to make me select text without a link).

Any thoughts on how I can achieve the below, but create a much longer
letter?

Thanks - Jenny B.


="In reference to your visit on " & Format([DateLastVisit],"mm/dd/yy")
& "
with " & [Physician] & ", your " & [TestType] " & came back with " &
[TestResult] & ". We have scheduled a followup visit on " &
Format([DateNextVisit],"mm/dd/yy") & "."