Label Visible if !

[Bob V]

On My Report:
My lable [lblCredit] , My TextBox [tbGrandTotal] can I make my label visible
if [tbGrandTotal] is >1
Thanks for any help..............Bob

 

[fredg]

On My Report:
My lable [lblCredit] , My TextBox [tbGrandTotal] can I make my label visible
if [tbGrandTotal] is >1
Thanks for any help..............Bob

Code the Section's Format event (of whatever section the label is in,
i.e. Detail Format Event):

Me.[lblCredit].Visible = Me.[tbGrandTotal] > 1

 

[Allen Browne]

Another way to do this without any code is to right-click the label and
choose:
Change To | Text Box.

Now set the Control Source of this text box to an expression such as:
=IIf([tbGrandTotal] > 1, "Your text to show here", Null)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

On My Report:
My lable [lblCredit] , My TextBox [tbGrandTotal] can I make my label
visible
if [tbGrandTotal] is >1
Thanks for any help..............Bob

Code the Section's Format event (of whatever section the label is in,
i.e. Detail Format Event):

Me.[lblCredit].Visible = Me.[tbGrandTotal] > 1

 

[Bob V]

Brilliant thanks Guys, Went with Allens
Regards Bob

Another way to do this without any code is to right-click the label and
choose:
Change To | Text Box.

Now set the Control Source of this text box to an expression such as:
=IIf([tbGrandTotal] > 1, "Your text to show here", Null)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

On My Report:
My lable [lblCredit] , My TextBox [tbGrandTotal] can I make my label
visible
if [tbGrandTotal] is >1
Thanks for any help..............Bob

Code the Section's Format event (of whatever section the label is in,
i.e. Detail Format Event):

Me.[lblCredit].Visible = Me.[tbGrandTotal] > 1