Making texboxes invisible depending on the value in them (1 Viewer)

[jer]

Hi,
How do you make a textbox invisible depending on the value within then. I have a continous form which shows a textbox for tool numbers. However, when the tool number is "UNKNOWN" how do I make it that it substitutes in the Serial number of the Tool in its place?
Please help!!
Jer

 

[Mr. B]

If you are using a query as the row source for your form then you can do what you want in the query not in the form. Just add a column to the query that using an IF statement to check the value of the ToolNumber and if that is "Unknown" then use the "SerialNumber" value else use the ToolNumber. Place this in a new column in the Field row of your query:

Tool: IIf([ToolNumber]="Unknown",[SerialNumber],[ToolNumber])

Just be sure to substitute the exact name of your fields in the appropriate references above.

This will create a field named Tool. Use this field in your form.

 

[jer]

Thanks Mr.B but I figured it out
Thanks anyway!!