Solved TextBox Issue

[mfaisal.ce]

Hello Friends,

I want to disable textbox edit in msaccess, i did it by using its property Locked= True but i want that even focus doesnot go to textbox like Labels....

my purpose is to make the textbox locked, visible and even can not be mouse clicked......

guide me plz....

 

[isladogs]

Disable it instead of locking it...or if you prefer do both.
Either will do what you want but the appearance will differ slightly.

 

[mfaisal.ce]

thanks dear....

 

[MajP]

but the appearance will differ slightly.

If you do not want the appearance to be different, I often
1. Lock the item
2. Set it to no tab stops so you cannot tab into it
3. Set the on focus to move it somewhere else.
This gives the same effect without the difference in appearance

@isladogs,
Can you override the "greyed out" appearance? I thought in previous versions of access you code. I cannot seem to now.

 

[isladogs]

@isladogs,
Can you override the "greyed out" appearance? I thought in previous versions of access you code. I cannot seem to now.

That's an interesting question and the answer depends on the control type
As you would expect, disabling any control makes them 'greyed out' (except for subforms), locking them does not cause 'grey out' .
However if you both lock & disable controls, some remain greyed out whilst others don't. I have no idea why

I modified my existing SetControls app to demonstrate this. See attached