Results 1 to 2 of 2

Border not appearing on blank fields - Report

  1. #1
    jmitchelldueck is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2015
    Posts
    51

    Border not appearing on blank fields - Report

    Hi,

    I have various reports I would like to be able to print. Each field in the report has a border that I would like to show whether the field is blank or has a value. This works for all the fields on my report except for one: my employee number field.

    Does anyone know why this might be or how I can fix it? The field is a number field.



    Thanks.

  2. #2
    jmitchelldueck is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2015
    Posts
    51
    I found the answer here. The CanShrink property needs to be set to No because it recognizes the blank field as having no value so it hides it completely.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Only certain fields appearing in lookup
    By ryanmce92 in forum Forms
    Replies: 6
    Last Post: 05-22-2015, 05:12 PM
  2. Replies: 2
    Last Post: 07-24-2013, 12:35 PM
  3. calculated fields appearing in table
    By jamhome in forum Access
    Replies: 16
    Last Post: 07-19-2011, 02:57 PM
  4. Replies: 2
    Last Post: 02-03-2011, 12:41 PM
  5. Border surrounding entire Report
    By yes sir in forum Access
    Replies: 1
    Last Post: 11-13-2010, 01:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums