Results 1 to 3 of 3
  1. #1
    darkdemon is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Posts
    12

    Grid Lines

    Hi again folks. I have a new problem for me, probably old for some others. Anyway I want to make grid lines on a report, when the fields are empty or null but only in the details section of the report. So if the form was completely empty it would show the headers/footers data and everything in between would look like a bunch of boxes. My report has 7 fields, all data is horizontal since all the data entry is based on a government form. Below that I need all the empty space to be filled with the boxes as I mentioned like a spreadsheet from excel.

    Thank you in advance.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    look at using the vba line method for reports

    https://docs.microsoft.com/en-us/off...ss.Report.Line

    Access is not a version of excel so as far as blank rows are concerned, this is not possible without records. You would need to create a number of blank records to achieve this. The records themselves can be populated, you just don't display any of the values. So your form recordsource might be something like

    SELECT TOP 10 "" as Blank FROM msysObjects

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    That line thing looks complicated!

    Not sure why you wouldn't just create a Word or Excel document and call that up if you're working in a db at the time you need it. I have no idea what's in your report header and footer so maybe some of these suggestions won't work.

    I suppose you could also use an unbound object frame but I've never tried to put on on a report to show another file.

    If you're stuck on using only Access and all you want is some kind of paper form, perhaps create a table with the field count & names you need, allow zls (zero length string) in each field. Then run an append query and fill the fields with "" and base your report on the table. If you need 7 rows in your report, run the query 7 times. Your report controls should show but be blank. That's untested by me.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 5
    Last Post: 09-24-2020, 10:29 AM
  2. Need Grid lines on null fields in report
    By lpkorn423 in forum Reports
    Replies: 1
    Last Post: 12-27-2012, 08:45 AM
  3. Grid Control
    By waqas in forum Forms
    Replies: 1
    Last Post: 06-27-2012, 03:40 PM
  4. Grid lines vs Grid Dots
    By dharriet in forum Access
    Replies: 0
    Last Post: 10-14-2008, 09:17 PM
  5. Grid Control - or something like that.
    By rhunt in forum Programming
    Replies: 1
    Last Post: 12-15-2005, 04:46 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
  •  
Other Forums: Microsoft Office Forums