Access 2007 removing white space from forms hidden fields

Hi,
I have an Access 2007 form that has fields that are sometimes null. I can hide these fields but I would like to remove the blank space they leave (gaps). The form is only used for reviewing data not data entry.
Thanks for any help
jgm
jgmatheAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

shambaladCommented:
DO you mean to say that you only want to hide these fields if they are null?
0
shambaladCommented:
Is this a single-record form? Or are you looking to hide columns in a continuous form?
0
jgmatheAuthor Commented:
I can already hide the fields if they contain nulls and this is a single record form.
Example
text1    abc
text2    abc

text4   abc

text3 is not visible because it contains a null but the space it occupied is there.
I need it to look like
text1  abd
text2  abc
text4  abc

Thanks for the help
jgm
0
shambaladCommented:
Wow - I am really sorry it took me so long to get back to you. This question simply got lost in the shuffle.
Anyway, attached is a solution.
Hide-Null-Lines.mdb
Relationships.jpg
tblHeader.jpg
tblDetail.jpg
Query-Design.jpg
Query-results.jpg
Form-design-view.jpg
Form-view-1st-record.jpg
Form-view-record-2.jpg
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.