Watermark

I am creating a report (which is really a label for a box), and I have a
yes/no field called Permanent. If Permanent is checked yes is there a way to
put this in the report so that the word Permanent could be stretched
diagonally across the page as a watermark? Thanks

On Mon, 30 Apr 2007 11:12:01 -0700, LindaC wrote:

I am creating a report (which is really a label for a box), and I have a
yes/no field called Permanent. If Permanent is checked yes is there a way to
put this in the report so that the word Permanent could be stretched
diagonally across the page as a watermark? Thanks

Diagonally?
Yes, but first you need to create an Image bitmap with the word
"Permanent" in large type, diagonal across the image. I created it
using Microsoft Digital Image Pro, which allows rotating text. You can
use any similar program (MSPaint does not allow text rotation).
Save the image as a .bmp image.

Then code the Report's open event:
If forms!YourFormName!CheckBoxName = True then
Me.Picture = "PathToPicture\PictureName.bmp"
Me.PictureSizeMode = 3 ' or 0 or 2 ... see the difference
End If

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

LindaC wrote:

I am creating a report (which is really a label for a box), and I have a
yes/no field called Permanent. If Permanent is checked yes is there a way to
put this in the report so that the word Permanent could be stretched
diagonally across the page as a watermark?


Add a text box bound to the yes/no field to the report. Set
its Height and Width to fill the detail section. Then set
its FontSize fairly large and Forecolor to light gray. Set
its Format property to
"";"Permanent";"";""
and then use the Format menu Send To Back to put it behind
all the other controls.

--
Marsh
MVP [MS Access]

Thanks. Not quite sure how to add a text bound box to the yes/no field? The
rest I can do. Please explain, thanks.

"Marshall Barton" wrote:

LindaC wrote:

I am creating a report (which is really a label for a box), and I have a
yes/no field called Permanent. If Permanent is checked yes is there a way to
put this in the report so that the word Permanent could be stretched
diagonally across the page as a watermark?


Add a text box bound to the yes/no field to the report. Set
its Height and Width to fill the detail section. Then set
its FontSize fairly large and Forecolor to light gray. Set
its Format property to
"";"Permanent";"";""
and then use the Format menu Send To Back to put it behind
all the other controls.

--
Marsh
MVP [MS Access]

Select Textbox on the Toolbox toolbar, then on the report
section where you want the text box drag an outline of the
text box. Delete any attached label. Then double click the
new text box to display its property sheet and enter/select
the name of the YesNo field in the ControlSource property.
--
Marsh
MVP [MS Access]


LindaC wrote:

Thanks. Not quite sure how to add a text bound box to the yes/no field? The
rest I can do. Please explain, thanks.

"Marshall Barton" wrote:

LindaC wrote:

I am creating a report (which is really a label for a box), and I have a
yes/no field called Permanent. If Permanent is checked yes is there a way to
put this in the report so that the word Permanent could be stretched
diagonally across the page as a watermark?


Add a text box bound to the yes/no field to the report. Set
its Height and Width to fill the detail section. Then set
its FontSize fairly large and Forecolor to light gray. Set
its Format property to
"";"Permanent";"";""
and then use the Format menu Send To Back to put it behind
all the other controls.

Hi Marshall:
Thanks for all your help. Still a little problem though, the control source
is working but it is coming out with a 0 or -1 value and not the word
Permanent. Any ideas?

"Marshall Barton" wrote:

Select Textbox on the Toolbox toolbar, then on the report
section where you want the text box drag an outline of the
text box. Delete any attached label. Then double click the
new text box to display its property sheet and enter/select
the name of the YesNo field in the ControlSource property.
--
Marsh
MVP [MS Access]


LindaC wrote:

Thanks. Not quite sure how to add a text bound box to the yes/no field? The
rest I can do. Please explain, thanks.

"Marshall Barton" wrote:

LindaC wrote:

I am creating a report (which is really a label for a box), and I have a
yes/no field called Permanent. If Permanent is checked yes is there a way to
put this in the report so that the word Permanent could be stretched
diagonally across the page as a watermark?


Add a text box bound to the yes/no field to the report. Set
its Height and Width to fill the detail section. Then set
its FontSize fairly large and Forecolor to light gray. Set
its Format property to
"";"Permanent";"";""
and then use the Format menu Send To Back to put it behind
all the other controls.

What did you put in the text box's Format property?
--
Marsh
MVP [MS Access]


LindaC wrote:
Thanks for all your help. Still a little problem though, the control source
is working but it is coming out with a 0 or -1 value and not the word
Permanent. Any ideas?

"Marshall Barton" wrote:

Select Textbox on the Toolbox toolbar, then on the report
section where you want the text box drag an outline of the
text box. Delete any attached label. Then double click the
new text box to display its property sheet and enter/select
the name of the YesNo field in the ControlSource property.


LindaC wrote:

Thanks. Not quite sure how to add a text bound box to the yes/no field? The
rest I can do. Please explain, thanks.

"Marshall Barton" wrote:

LindaC wrote:

I am creating a report (which is really a label for a box), and I have a
yes/no field called Permanent. If Permanent is checked yes is there a way to
put this in the report so that the word Permanent could be stretched
diagonally across the page as a watermark?


Add a text box bound to the yes/no field to the report. Set
its Height and Width to fill the detail section. Then set
its FontSize fairly large and Forecolor to light gray. Set
its Format property to
"";"Permanent";"";""
and then use the Format menu Send To Back to put it behind
all the other controls.

Thank you, changed to Yes/No

"Marshall Barton" wrote:

What did you put in the text box's Format property?
--
Marsh
MVP [MS Access]


LindaC wrote:
Thanks for all your help. Still a little problem though, the control source
is working but it is coming out with a 0 or -1 value and not the word
Permanent. Any ideas?

"Marshall Barton" wrote:

Select Textbox on the Toolbox toolbar, then on the report
section where you want the text box drag an outline of the
text box. Delete any attached label. Then double click the
new text box to display its property sheet and enter/select
the name of the YesNo field in the ControlSource property.


LindaC wrote:

Thanks. Not quite sure how to add a text bound box to the yes/no field? The
rest I can do. Please explain, thanks.

"Marshall Barton" wrote:

LindaC wrote:

I am creating a report (which is really a label for a box), and I have a
yes/no field called Permanent. If Permanent is checked yes is there a way to
put this in the report so that the word Permanent could be stretched
diagonally across the page as a watermark?


Add a text box bound to the yes/no field to the report. Set
its Height and Width to fill the detail section. Then set
its FontSize fairly large and Forecolor to light gray. Set
its Format property to
"";"Permanent";"";""
and then use the Format menu Send To Back to put it behind
all the other controls.

The predefined Yes/No format is:
"Yes";"Yes";"No";""
The first part is used for values that are 0, the second
part for values 0. the third part for zero values and the
fourth part for Null values. Since a YesNo type field in a
table can only have a value of -1 or 0, only the second and
third parts will be used.

All I was suggesting is that you use different text than the
Yes and No:

"";"Permanent";"";""
--
Marsh
MVP [MS Access]


LindaC wrote:

Thank you, changed to Yes/No

"Marshall Barton" wrote:

What did you put in the text box's Format property?


LindaC wrote:
Thanks for all your help. Still a little problem though, the control source
is working but it is coming out with a 0 or -1 value and not the word
Permanent. Any ideas?

"Marshall Barton" wrote:

Select Textbox on the Toolbox toolbar, then on the report
section where you want the text box drag an outline of the
text box. Delete any attached label. Then double click the
new text box to display its property sheet and enter/select
the name of the YesNo field in the ControlSource property.


LindaC wrote:

Thanks. Not quite sure how to add a text bound box to the yes/no field? The
rest I can do. Please explain, thanks.

"Marshall Barton" wrote:

LindaC wrote:

I am creating a report (which is really a label for a box), and I have a
yes/no field called Permanent. If Permanent is checked yes is there a way to
put this in the report so that the word Permanent could be stretched
diagonally across the page as a watermark?


Add a text box bound to the yes/no field to the report. Set
its Height and Width to fill the detail section. Then set
its FontSize fairly large and Forecolor to light gray. Set
its Format property to
"";"Permanent";"";""
and then use the Format menu Send To Back to put it behind
all the other controls.

Thank you for staying with me, it is working perfectly.

"Marshall Barton" wrote:

The predefined Yes/No format is:
"Yes";"Yes";"No";""
The first part is used for values that are 0, the second
part for values 0. the third part for zero values and the
fourth part for Null values. Since a YesNo type field in a
table can only have a value of -1 or 0, only the second and
third parts will be used.

All I was suggesting is that you use different text than the
Yes and No:

"";"Permanent";"";""
--
Marsh
MVP [MS Access]


LindaC wrote:

Thank you, changed to Yes/No

"Marshall Barton" wrote:

What did you put in the text box's Format property?


LindaC wrote:
Thanks for all your help. Still a little problem though, the control source
is working but it is coming out with a 0 or -1 value and not the word
Permanent. Any ideas?

"Marshall Barton" wrote:

Select Textbox on the Toolbox toolbar, then on the report
section where you want the text box drag an outline of the
text box. Delete any attached label. Then double click the
new text box to display its property sheet and enter/select
the name of the YesNo field in the ControlSource property.


LindaC wrote:

Thanks. Not quite sure how to add a text bound box to the yes/no field? The
rest I can do. Please explain, thanks.

"Marshall Barton" wrote:

LindaC wrote:

I am creating a report (which is really a label for a box), and I have a
yes/no field called Permanent. If Permanent is checked yes is there a way to
put this in the report so that the word Permanent could be stretched
diagonally across the page as a watermark?


Add a text box bound to the yes/no field to the report. Set
its Height and Width to fill the detail section. Then set
its FontSize fairly large and Forecolor to light gray. Set
its Format property to
"";"Permanent";"";""
and then use the Format menu Send To Back to put it behind
all the other controls.