You need code like:
Me!MyCommandButton.Visible = (Me!MyTextBox = "MyDesiredValue")
Change the names of MyCommandButton and MyTextBox to the appropriate control
names, as well as changing the text.
Is the value in the text box going to be changed by typing in the text box,
or simply by navigating from one record to another?
In the first case, put that code into the text box's AfterUpdate event. In
the second case, put it into the Form's Current event.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
<te**********@hotmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
I have a text box where the value in the text box determined whether a
command button is visible or not, is this possible. If so how would i
go about implementing it?