Watermark

[Guest]

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

 

[fredg]

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

 

[Marshall Barton]

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.

 

[Guest]

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]

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.

 

[Guest]

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?

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]

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]

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

 

[Guest]

Thank you, changed to Yes/No

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

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]

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";"";""

 

[Guest]

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

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]

Thank you, changed to Yes/No