Need a control on line.

[Tim]

Hi everyone,

I built a report that had combo boxes on it. I set the
properties of those combo boxes to CAN GROW and CAN
SHRINK. I also drew some lines underneath the combo
boxes. If the combo boxes didn't contain the null value,
then the report look fine. If the boxes contained null
value, the report would be a mess. Does anyone know how
to set the line to invisible when the boxes contained null
value?

Any help will be deeply appreciated.

Thanks.

Tim.

 

[Duane Hookom]

You could use code in the On Format event of the section containing the
controls:

Me.linMyLine.Visible = Not IsNull(Me.cboMyCombo)

 

[Tim]

Duane,

Thanks for your help.

Tim.

-----Original Message-----
You could use code in the On Format event of the section containing the
controls:

Me.linMyLine.Visible = Not IsNull(Me.cboMyCombo)

--
Duane Hookom
MS Access MVP





.