Event Changing Text Box BackColor

[Chris Windsor]

I'm building a data input form for IC components, and one of the fields is
for memory size (e.g. 4 MBytes). This field will only need data when the
component is of a memory type (e.g., DRAM, SRAM, Flash, EPROM, etc.); which
is set in another text field. I want the memory size field to be
highlighted by having a bright backcolor when two conditions exists: the
component is of a memory type, and when the size field is null. This is to
alert the operator to put some value there; once they have, the backcolor
should change back to white like the rest of the form.

TIA

 

[Ken Snell]

If you have ACCESS 2000 or 2002, you probably could use the Conditional
Formatting to do this. Take a look at it and post back if you need more
information.