Text objects

  • Thread starter Thread starter jayC
  • Start date Start date
J

jayC

I am creating customer invoices using a query report.

What is the best way to place text into the report that is not tied to a
field? Examples of such text are: "Bill to:" and "Date."

I tried using text boxes but, as usual, ran into problems.

If I should use text boxes, how specically do I accomplish this for the text
I am trying to insert?

Thanks
 
Do you mean that you want a text box with different values to appear in the
report when you open it?
If eg you want a filtered report to give the name of the customer it
concerns, you can put a text box in it saying

="Bill to: " & [CustomerName]

(assuming you have a field called CustomerName either in your report or in
the query on which it is based)

Because your report has been filtered to show only one customer, the correct
name will appear in this text box when the filtered report is opened.

Or do you mean that you want the report to ask for this info when you open
it so that the report can be filtered?

Evi
 
No. I just need text such as "Bill to:" or "Date:" I don t need different
values. It is the same on every page, like the logo.
The customer field would appear below the text that reads, "Bill to:" etc..
I just need to know how to place the words "Bill to:" in the report.

Evi said:
Do you mean that you want a text box with different values to appear in
the
report when you open it?
If eg you want a filtered report to give the name of the customer it
concerns, you can put a text box in it saying

="Bill to: " & [CustomerName]

(assuming you have a field called CustomerName either in your report or in
the query on which it is based)

Because your report has been filtered to show only one customer, the
correct
name will appear in this text box when the filtered report is opened.

Or do you mean that you want the report to ask for this info when you open
it so that the report can be filtered?

Evi


jayC said:
I am creating customer invoices using a query report.

What is the best way to place text into the report that is not tied to a
field? Examples of such text are: "Bill to:" and "Date."

I tried using text boxes but, as usual, ran into problems.

If I should use text boxes, how specically do I accomplish this for the text
I am trying to insert?

Thanks
Click to expand...
Click to expand...
 
Hi jayC
Don't put the Text Box try the Label (the other icon with an A in capsLock).
Good luck

jayC said:
No. I just need text such as "Bill to:" or "Date:" I don t need different
values. It is the same on every page, like the logo.
The customer field would appear below the text that reads, "Bill to:" etc..
I just need to know how to place the words "Bill to:" in the report.

Evi said:
Do you mean that you want a text box with different values to appear in
the
report when you open it?
If eg you want a filtered report to give the name of the customer it
concerns, you can put a text box in it saying

="Bill to: " & [CustomerName]

(assuming you have a field called CustomerName either in your report or in
the query on which it is based)

Because your report has been filtered to show only one customer, the
correct
name will appear in this text box when the filtered report is opened.

Or do you mean that you want the report to ask for this info when you open
it so that the report can be filtered?

Evi


jayC said:
I am creating customer invoices using a query report.

What is the best way to place text into the report that is not tied to a
field? Examples of such text are: "Bill to:" and "Date."

I tried using text boxes but, as usual, ran into problems.

If I should use text boxes, how specically do I accomplish this for the text
I am trying to insert?

Thanks
Click to expand...
Click to expand...
Click to expand...
 
How do I turn off the exclamation mark which appears when I create the Label
box and a caption is inserted?
Thanks
Vieira said:
Hi jayC
Don't put the Text Box try the Label (the other icon with an A in
capsLock).
Good luck

jayC said:
No. I just need text such as "Bill to:" or "Date:" I don t need
different
values. It is the same on every page, like the logo.
The customer field would appear below the text that reads, "Bill to:"
etc..
I just need to know how to place the words "Bill to:" in the report.

Evi said:
Do you mean that you want a text box with different values to appear in
the
report when you open it?
If eg you want a filtered report to give the name of the customer it
concerns, you can put a text box in it saying

="Bill to: " & [CustomerName]

(assuming you have a field called CustomerName either in your report or
in
the query on which it is based)

Because your report has been filtered to show only one customer, the
correct
name will appear in this text box when the filtered report is opened.

Or do you mean that you want the report to ask for this info when you
open
it so that the report can be filtered?

Evi


I am creating customer invoices using a query report.

What is the best way to place text into the report that is not tied
to
a
field? Examples of such text are: "Bill to:" and "Date."

I tried using text boxes but, as usual, ran into problems.

If I should use text boxes, how specically do I accomplish this for
the
text
I am trying to insert?

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Click on the Label and the exclamation mark will appear, put the mouse on it
and you can see an arrow. Click on the arrow and on the Ignore Error. I think
you are triyng to put a "floating" text, so you don't need to associate with
any Control

jayC said:
How do I turn off the exclamation mark which appears when I create the Label
box and a caption is inserted?
Thanks
Vieira said:
Hi jayC
Don't put the Text Box try the Label (the other icon with an A in
capsLock).
Good luck

jayC said:
No. I just need text such as "Bill to:" or "Date:" I don t need
different
values. It is the same on every page, like the logo.
The customer field would appear below the text that reads, "Bill to:"
etc..
I just need to know how to place the words "Bill to:" in the report.

Do you mean that you want a text box with different values to appear in
the
report when you open it?
If eg you want a filtered report to give the name of the customer it
concerns, you can put a text box in it saying

="Bill to: " & [CustomerName]

(assuming you have a field called CustomerName either in your report or
in
the query on which it is based)

Because your report has been filtered to show only one customer, the
correct
name will appear in this text box when the filtered report is opened.

Or do you mean that you want the report to ask for this info when you
open
it so that the report can be filtered?

Evi


I am creating customer invoices using a query report.

What is the best way to place text into the report that is not tied
to
a
field? Examples of such text are: "Bill to:" and "Date."

I tried using text boxes but, as usual, ran into problems.

If I should use text boxes, how specically do I accomplish this for
the
text
I am trying to insert?

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top