Input Box

[EliseFreedman]

Hi there

I have an input box on my form which I am using to get a value which I am then using to search a table.

Is there any way in which I can alter the background colour of an input box

 

[SQLBI]

Elise,

No there isn't. If you really want a different colour, create a new form and change the BackClour property of the Form/Control.

You can then use this in the same way as you would the InputBox

Leigh Moore
LJM Analysis Ltd

http://www.ljm-analysis.co.uk

 

[cranebill]

Input box on a "form" yes there is. By input box on a form i am assuming you mean either a text box or a combo box.

you can use...
Me!Textboxname!backcolor = 255 (in this example 255 is red)

if its on another form you can use
Forms!FormName!TextBoxName.backcolor = 255


Bill