Macro to change object property

  • Thread starter Thread starter yaronh
  • Start date Start date
Y

yaronh

Guest
I would like to create a macro that will change the property of a given textbox in a form from hidden to vissible. I couldn't find any function that will do it and my VBA skills are somehow limited. Anyone can help ??
 
Yaronh

You should be able to use a simple If, Then, Else statement in VB to solve this problem.

Code:
If [YourFieldName] meets some condition Then
Me.[YourTextBoxName].Visible = True
Else
Me.[YourTextBoxName].Visible = False
End If

Post further information as to what exactly you are trying to do, then we should be able to help further

Graham
 

Users who are viewing this thread

Back
Top Bottom