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

Posted on 2014-08-29
Last Modified: 2014-08-29
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?

Question by:gdunn59
    LVL 119

    Expert Comment

    by:Rey Obrero
    is the "Border Style" of the textbox  set to Solid ?

    Author Comment

    Yes it is set to Solid.

    Author Comment

    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.
    LVL 33

    Accepted Solution

    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 Closing Comment

    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!!!!!!


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now