How can I create a label in Microsoft Access that ignores empty fields and moves the remaining fields up?

Jeff Toombs 0 Reputation points
2024-05-23T04:03:46.13+00:00

I have a form that is a label and I need to have this as a sort of "general purpose" label so there may be a field missing from time to time (Company Name) that when the label prints, it ignores that field and moves the rest of the fields up so I don't have a huge white blank on the label. Is there an easy way to do this? I'm a newbie and I don't know any programming languages so I was hoping there was a way to do this in Access directly.

Regards,

J

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
400 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.