Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1713
  • Last Modified:

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

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
0
gdunn59
Asked:
gdunn59
  • 3
1 Solution
 
Rey Obrero (Capricorn1)Commented:
is the "Border Style" of the textbox  set to Solid ?
0
 
gdunn59Author Commented:
Yes it is set to Solid.
0
 
gdunn59Author 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.
0
 
PatHartmanCommented:
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.
0
 
gdunn59Author 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
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now