change background color of textfield

[vikram_singh]

Hi,

I have one criteria to change the backcolor of textfield which is in
TABULAR form. i have added on button next to the textfield, which
opens the colour plate and user selects the color according to his
choice

so according to my code it is changing the colour of all text boxes
which is having name Q1txt.

M very new to VBA and dont know where is it possible in Tabular Form
to change specific textbox colour or not.

Kindly do let me know if that is possible.

Thanks in Advance.

VS

 

[Stefan Hoffmann]

hi Vikram,

I have one criteria to change the backcolor of textfield which is in
TABULAR form. i have added on button next to the textfield, which
opens the colour plate and user selects the color according to his
choice

In continues, endless form, you can't address controls per row. This is
by design.

You may take a look at lebans.com, he has a bunch of soultions for that.


mfG
--> stefan <--