Forms and fields that are blank

[realtallgal]

I built a form for 154 records, but I don't want the form to displace a field if the results are blank. FOr example,years 2000-2010, I have one customer that has data for all, but another that only has data for 2000-2005, I don't want that record to show 2006-2010 field names when the data would be blank

 

[dhookom]

realtallgal,
Can you share your table structure, some sample records, and what you would like to display in your form? Can we assume the form displays only a single record at a time?


Duane
Hook'D on Access
MS Access MVP

 

[realtallgal]

Yes, see attached, shows my query set up... see that some fields have values for MDEP others do not.. if they don't have a value I don't want them to show up on on my form. The problem is that I can't exclude the field name ( use the don't show option) because in some cases the field is populated with results.


it won't let me upload a docuemnt

 

[dhookom]

realtallgal,
Please type in your answers using TGML if at all possible.
I'm not sure you answered if you form is single or continuous.

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

How are ya realtallgal . . .

As a 1st guess ... your query needs a [blue]WHERE[/blue] clause something like:

[blue]   WHERE ([MDEP] Is Not Null)[/blue]

This will only return records where [blue]MDEP[/blue] has a value. Post the [blue]SQL[/blue] of the query so we can have a look.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]