Changing control properties

[incagold]

Hi all,

Another newbie question. We are designing a form which will have several text boxes displayed in a grid (e.g. txtSN1, txtSN2, txtSN3, txtSte1, txtSte2, txtSte3, etc.).

Question: Is it possible to hide the boxes that will not be used at a given time by changing the control property to .visible = false in a For .. Next loop by using the Right function to determine the number of the box to hide? The boxes will be used in varying combinations and we would like to only display the boxes containing data.

Thank you in advance for any assistance.

REF

 

[scriverb]

Yes, you can do this as you described. But rather than make them invisible you can also modify the .enabled property to false to make them become unavailable for use. They take on a half-color look and the user cannot tab or click into the textbox.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[RoyVidar]

Hi!

Yes, thru for intance looping thru the form controls, you can use different criterias for changing control properties. Here's a thread on it, thread705-786249.

Roy-Vidar

 

[incagold]

Hi scriverb and RoyVidar,

Thank you both for the rapid response and suggestions. I have tired the looping technique on one series setting .enabled to false. Works great.

Thanks agin for your help and rapid response.

REF