On Sat, 19 Mar 2005 19:06:46 +1100, Paolo wrote:
I need to create a button which changes the back colour and the font colour
and type of several fiels in a form, This is the way I would normally do it:
[Date].Backcolor = 11112121
[Date].tabstop = True
[Customer No].Backcolor =
etc
is there a way I can do it for all of them grouped together, given that the
whole group needs to change to the same colours?
Thanks
Paolo
You've received several replies by now, telling you how to change
control properties, so I'll call your attention to another aspect of
database design you may not be aware of... your use of the word "Date"
as a field name.
Date is a reserved Access/VBA/Jet word and should not be used as a
field name.
See the Microsoft KnowledgeBase article for your version of Access:
109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.