Finding the controls on a form

[Dryseals]

I have two tables, both are identicle field names and records. The first table is a base that never changes, the second is where the editing the records takes place.

On a form where the people edit the second table, I would like to change the background color of any field that does not match the base table. The field names are exact matches for the form control names and rather than type each individual one out, is there a way to use the field name of the table to find the control name of the form.

Such as
Me."the field name" some syntax that would work
or
extract the field name from the form.control.item number

 

[dtqbterror]

Me.Controls(fieldname)

http://www.chiefscoalition.com

 

[Dryseals]

Thank you, I figured it out shortly after posting, works very well with the exception of check boxes. I now have to find out what how to determine if the control is a textbox or not.
Then again I could always arrange the sql into text bow first and then stop at the count, but determining the type of control could be usefull in the future.

Thanks Again

 

[RoyVidar]

Try searching for ControlType in the help files. You might also find some tips here faq702-5010.

Roy-Vidar