change color in many text box

[florin]

I have a form which takes information from a query.
The information is orizontally aranged in the many text boxes .
I would like to know how can i change the background color of the text box
on the row by just doubleclicking on that particular row.
Give me some suggestions please!

Thanks
Florin

 

[Ron2006]

The actual command to change the background color is
me.fieldname.backcolor = # ' # for the color
you want or vbRed or some such to represent the color.


HOWEVER

1) it will not work on a datasheet view.
2) There is no event for row doubleclick
3) if you use form doubleclick it will change it for single form and
continuous form but it will change it for ALL records
4) If you use a field doublclick it will function the same as 3 above.
5) If you close the form and then open it again it will not know that
it has been done and all records will be back to as if you had NOT
double clicked.


What are you trying to do with this doubleclick process? If you tell
us what you are trying to do we can better reply to your question.


Ron

 

[florin]

- I use small font in a many text boxes into a form because I have 25 text
boxes
orizontally into a details form. In a few text boxes I can modify the
data and that affected another calculated text box
- in form view, is very hard to follow the information, for each record, for
left(first) to right (25-th text box)
- would like to know how can i change the background color of the text box
on the one row (selected row, that one witch has information that I want
special view)

thanks for all
florin

 

[Ron2006]

Here is a possibility if you have control of the tables and can add
another field.

On some datasheet forms that we use here we help them by letting the
user know if they have modified the record that day. When they change
certain fields we place today's date in a field called "Modified
today" and then on a given set of fields we have conditional formating
that if [Modified Today] = date() then we change the background color.

If you can add a field, you could pick a field to have the double
click on and if that field had a value then make it null and if it was
null then make it today's date. (or a yes/no field and switch the
values).
Then have conditional formating on whatever fields you want and change
the background color dependent on the switch or the date = today's
date.

Ron