VisualBasic Code for Microsoft Access

[mrollz]

It's been a while since I've had to do coding in VisualBasic, so I'm quite rusty. However I'm using Microsoft Access to create a report of all the projects and their corresponding data (file paths, descriptions, file names, etc) that I've completed. What I've done is create separate tables for each piece of data. For example, I have a table devoted to what's called "Batch Point Files" for each project. My problem is that while some jobs have over 15 batch point files, some have none. When I run my report, Access reserves a blank line on each page for these files that don't exist for some projects. I would basically like to be able to write a short function that will essentially hide these fields in the report if they are empty. Something like:
If (field(x) = null) Then
field(x).Visible = False
End If
I'm having trouble moving from the above pseudocode to working code that will also hide all the fields after field(x).
Any help you can offer will be very much appreciated. If I've been unclear about what I need, I can and will provide more information. Thank you.
Regards,
Matthew Rowles
Town of Chapel Hill
Engineering

 

[BobRodes]

This is Access VBA code, I do believe. I'm assuming that you're using Access's reporting function rather than some other one. You might want to repost this to forum705.

Good luck,

Bob

 

[mrollz]

cool will do, thanks Bob
Regards,
Matthew