Print rectangle box even if there is no data

[azzurri]

One thing I notice that when you place some field in a report in line and put a rectangle box around those fields (like you format a borderline around a cell in Excel worksheet), it will only appear if there is data,if no data, the rectangular box not printed out. Is it possible that even if there is only one row(line) of record in a report, the rectangular box will appear as 30 rows. I need this to happen to comply with my company report format. (the standard report fix thirty rows of rectangular box which easily can be done on Excel worksheet).

Any solutions welcome.

 

[Fizzio]

I'm sure that you can do it with vbCode but have you considered transferring the data to excel and printing from there?

 

[azzurri]

transfering it to excel is not a practical solution since you will lose some of the report format in excel.

 

[Rich]

http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=111144#post111144

 

[DAPPLE]

Another way of putting a border around your field is by clicking the linecolor in the toolbar from transparent to black, or color of preference.