Continous Form

[Martin]

Hello, I have a question regarding a continuous form. I
created a tabular form that has a few textboxes (Date,
LastName, FirstName, Position etc...) At the beginning of
each line in the form I have a command button that changes
the backcolor of each textbox to yellow. The problem is
that my code changes all the texboxes backcolors. What I
would like to happen is for only one line of textboxes on
the tabular form to change backcolor. Is this possible, if
so could someone help me out with the code. My original
code is set to the onClick command of the command button.
Thanks ahead of time,
Martin

 

[Trias]

Hi Martin,

if you use Access 2000 and above, you might try conditional formatting in the menu FORMAT. But check out the web site of Stephen Lebans ( http://www.lebans.com/products.htm ), he had tons of wonderfull thing of this kind.

Hope this help.

----- Martin wrote: -----

Hello, I have a question regarding a continuous form. I
created a tabular form that has a few textboxes (Date,
LastName, FirstName, Position etc...) At the beginning of
each line in the form I have a command button that changes
the backcolor of each textbox to yellow. The problem is
that my code changes all the texboxes backcolors. What I
would like to happen is for only one line of textboxes on
the tabular form to change backcolor. Is this possible, if
so could someone help me out with the code. My original
code is set to the onClick command of the command button.
Thanks ahead of time,
Martin