Sub Form Behavior with background text box

[chungiemo]

Hi

Wondering if any can give me some guidance

I managed to have a working sub form and with a text box behind the transparent textboxes, The text box behind is mapped to a Table which allows my background to change color depending on the linked bitmap image behind it. But its behavior is acting strangely as when clicking nearer to the right hand side of the form on a selected record seems to put focus on the background text box thus making all my text with the front fields non visible. I have made sure the front text boxes cover the entire area of the text box from behind. Looked at all text box settings at the front but I can't see why this behavior is now occurring.

Would it be possible to set the backgound text box to never focus in VBA?

 

[Ranman256]

Set the property TAB STOP = false

 

[chungiemo]

Thanks for the reply but still when clicking a record the text box behind sets focus

 

[Ranman256]

Yes ,if the text box is there,the user can click it.
I don't know why you need a text box.
You can colorize the form,
Or a label. None of which can be selected.

 

[chungiemo]

Hi managed to work it out, staring in front of me :banghead:, had to set the textbox setting "Enabled" to False. Though strange and can't click at the right hand side of sub form to open a record, I will recreate the form as I think one of text settings is causing this.

Reason for the text box is to have more conditional format options and this was alernative way to do this.

Thanks for help