Collapse Question

[Arv]

Hi,
I'm new to this forum and I must admit that I'm overwhelm with the amount of information you guys provide here.
I'm developing a database for a real estate company. At this stage I'm generating reports and I have an estetic problem with one of them. It's a survey type of report, that generates a few information about each property. For example:

Address: 123 Main Street
Ground Size: 23,000 Square feet
Frontage: 20 Feet
Rent: $123PSF


Address: 2354 Big Street
Ground Size: 253,000 Square feet
Frontage: 20 Feet
Rent: $123PSF

etc...

The problem is that some records I use dont have all the information in. For Example:

Address: 2354 Big Street
Ground Size: 253,000 Square feet
Frontage:
Rent: $123PSF

How to force Access to omit the field and go like this :

Address: 2354 Big Street
Ground Size: 253,000 Square feet
Rent: $123PSF

Any hints will be highly appreciated
Thanks in advance

 

[ansentry]

First, Welcome to the Forum.

Have a look at the attached sample; it should do what you want. It is NOT my code and I don't know where I got it from so I can't acknowledge someone’s good work.

Good Luck.

 

[Arv]

thanks so much. That's definitely what I need. Should I copy and modify the module, or is there anything else I need to do? Sorry for the lame question but I'm new to database programming.

 

[iamrah]

Just tagging this thread, had a similar issue.

 

[ansentry]

Arv,

When I look at your problem I don't think that the sample I posted is for you. I would be better used on address labels or lists, when you do not require labels to identify controls.

Have a look at my attached sample it may be what you want. In your case I thing that the report should indicate "empty" controls, so that the information can be obtained and entered.

...............just my 2 cents worth.

iamrah,

I don't know what you are trying to do so can't offer any advise.

 

[Arv]

Ans,thanks for your answer. Sample you provided is close, and I highly appreciate it.I need to completely remove the field if it's empty. It's gonna be for a survey. It has to be unified, with no blank spaces. If field is empty, it shouldn't be visible, and move the field below it up.

 

[Egad]

This thread looks like it might help me out but I don't see the attachment that Ansentry referred to. What do I look for?