Dim empty records in a report

[10TR]

Is it possible to dim a record in a report if it is null?

 

[dhookom]

Can you define "dim". Records are generally not "null". A field value might be "null". If a field is "null", there is nothing there to see anyhow so why would you want to "dim" it?

Duane
Hook'D on Access
MS Access MVP

 

[10TR]

For example: The room combo field usuall has a record like "205 206" or something like that. If the room can't be combined then the field is empty but it's still displayed on the report.

 

[PWise]

As Duane Said:
Can you define "dim".

But look @ Conditional Formatting

 

[dhookom]

combo field"? "room can't be combined"?

Are you suggesting you don't want a border to display? If so, you might be able to set the Can Shrink property to yes.


Duane
Hook'D on Access
MS Access MVP

 

[10TR]

Sorry this is hard to explain.

I have a report that gives information about meeting rooms. Things like Room number, Presenter Name, Meeting Title, and Meeting Type. Meeting Type is usually populated with something like, Breakout Meeting, General Session, and State Meeting. However when Meeting Type is Break or Lunch I would naturally not have a presenter, room number or anything else. So, on the report I just have lables with no data. The report would look cleaner if during these times the lable would not show and that area would shrink.

I hope this helps...thanks

 

[dhookom]

I would change the labels to text boxes. Set the control properties to something like:
Control Source: "Presenter: " + [Presenter Field]
Can Shrink: Yes
Can Grow: No
Set the width of the control to display only what you want for the label. When the [Presenter Field] is null, the label will disappear.


Duane
Hook'D on Access
MS Access MVP