How to show borders of a text box in MS Access even if there is no data

gdunn59
gdunn59 used Ask the Experts™
on
I have a report in Access that has a "Comments" text box.  If there is no comments in this field, the border does not show, so all the other fields on this report have a border, but this field looks blank.

How can I get the text box "Comments" to show the border whether there is data or not?

Thanks,
gdunn59
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

Commented:
is the "Border Style" of the textbox  set to Solid ?

Author

Commented:
Yes it is set to Solid.

Author

Commented:
As I mentioned above, as long as that "Comments" field contains data it shows the border, but if that field does not contain any data, it doesn't show the border.
Distinguished Expert 2017
Commented:
I just ran into this exact problem today.  The problem is caused by the CanShrink setting.  For text fields on a report, I always set CanShrink and CanGrow to Yes.  I also rarely box items but today I created a report where I wanted the boxes.  You have to set CanShrink to No.  It actually makes sense if you think about it.  What the CanShrink does is eliminate a field if it is empty and that would mean its "box" also.  In this case, you really don't want the field to shrink away because you want the box regardless.

Author

Commented:
OMG, yes it did work.  You are a God Send.  Thank you so very much.  I thought I was going to have to write some sort of code to do it.

But as you indicated, that does make sense.

Thanks again, great job!!!!!!

gdunn59

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial