Creating Rectangles

[Kevin]

Hi Everyone.

Could anyone please tell me what I need to do, or point me
in a direction that will explain to me how to draw a
rectangle in a report. I am using Access 2000, and in my
report, if a field is null, I want to create blank lines
that the user can write in when the report is printed. For
this I need to draw a certain amount of rectangles, but I
do not know how to do it.

Any help is much appreciated
TIA
Kevin

 

[Allen Browne]

It is possible to do this with Conditional Formatting so you need no code.

Create a text box with these properties:
Height 0.002 in
Border Style Transparent

Select it in design view, and choose Conditional Formatting from the Format
menu.

Set Condition 1 to:
Expression Is ... [MyField] Is Null
and choose black in the bucket icon.

This text box will now be black when MyField is blank. Using conditional
formatting like this is much faster than using code in the Format event of
the section.