BackStyle

[Alan T]

What is the code to set a text box style to Transparent?
I tried
Forms![frmEmployee].txtName.BackStyle = Transparent
Forms![frmEmployee].txtName.BackStyle = 0

but no luck

 

[Steve]

Is the name of the textbox "txtName"? Open your form in design view, select
the textbox and look in the controls dropdown in the menu at the top of the
screen to check. Forms![frmEmployee].txtName.BackStyle = 0 is the correct
syntax if the form is named FrmEmployee and the textbox is named TxtName.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Alan T]

Yes, this is the correct syntex.
But the problem is when I click the text box it appears as white.
How do make it the same color as transparent even when I click the text box?
I don't want to disable it because I will set the tab index = 0.

Is the name of the textbox "txtName"? Open your form in design view,
select the textbox and look in the controls dropdown in the menu at the
top of the screen to check. Forms![frmEmployee].txtName.BackStyle = 0 is
the correct syntax if the form is named FrmEmployee and the textbox is
named TxtName.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

What is the code to set a text box style to Transparent?
I tried
Forms![frmEmployee].txtName.BackStyle = Transparent
Forms![frmEmployee].txtName.BackStyle = 0

but no luck

 

[missinglinq via AccessMonster.com]

Select your Detail section of the form
Find the Back Color Property and copy the entry there (should be -2147483633
if you have the default color set for the form)
Select your text box and goto it's Back Color Property and past in the color
code
Now when you click on the text box it'll be the same coor as your form