Disabling Textboxes Based On Other Textbox

[glerwell]

Hi

How do I disable a textbox based on another textbox's value and disable that textbox too.

For example,

If Textbox2 equals 0.00 than disable both textboxes 1 and 2.

Also, is there a way that a textbox cannot be selected when the tab or return key is pressed with out actually disabling it. Such as removing it from the tab order.

If not could the above be done but using a label and textbox.

So if label1 equals 0.00 then disable textbox2 and label1.

thanks

 

[Norie]

There are various ways to enable/disable controls and also various ways to avoid them being selected, tab to etc.

If you want to do something based on what's entered in a control then you are probably looking at some event code and the Enable property.

There are various events you could try - Change, Exit, AfterUpdate etc.

Those are for textboxes, and which to and how to use them really depends on what you want to do and when you want it to happen.

For the tabbing part most controls have TabIndex and TabStop properties, again how to use them depends on what you want to achieve.

PS Just remembered there's the Locked property too.

 

[glerwell]

Thanks Norie, I think I have an idea with the coding using change_event.

I didn't know about the tabstop property and have managed to ge that working.

Cheers