Changing the visible atribute of a control according to a value.

[Wiz Master via AccessMonster.com]

Hi guys I need to complete a school assignment and I am well aware on how
to coded in visual basic however in access its not working for me.

I need to make a label visible only when the value of a textbox control is,
= or > than 1000. Can you point me in the right direction.

 

[Graham R Seach]

Me.lblMyLabel.Visible=(Me.txtMyTextBox >= 1000)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Wiz Master via AccessMonster.com]

Well thank you for the responce. However it still does not work properly it
makes the label visible when the 1000 or more value is set however when I
change the record it stays visible even when the value is not >= 1000.
So I need it to perform the task every time a record is changed what event
should I coded in.

This is how I need it to work. The label should become visible when value
is => 1000 then if I change the record and value is < than 1000 it should
become invisible.

Thanks ahead for your help.

 

[Graham R Seach]

Put the line of code in two events; the form's Current event, and the
control's AfterUpdate event.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Wiz Master via AccessMonster.com]

Thank you very much.
If it had been in VB.Net I could have done it with my eyes closed. Heheheh

 

[Graham R Seach]

It's the same in dotnet.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html