visibility

[Michael]

access 2000
i have a continuous form showing all records from a table.
i would like to make a certain feild look blank, but still
be able to access the data in that field if the field
equals zero. i have tried using macros to adjust the
forecolor to the same as the background color, however, it
changes the color for all the records based on which
record is current, not for each individual record. so if
the current record is zero, the specific field for all
records is "hidden". i have tried to run the macro in
different areas in the "events" of the form and fields,
not sure if i'm using the right event or if this is
possible using the events. any ideas on another method,
or something i'm doing wrong.

macro:
setvalue
item:[field].[forecolor]
expression[field]=0)*-12632256

 

[Steve Schapel]

Michael,

You can't do this with a macro. A change to the forecolor property
applies to all records in the form. You can achieve the desired
result by using Conditional Formatting (under the Format menu in the
form design window).

- Steve Schapel, Microsoft Access MVP

 

[Guest]

i have done this in excell, but i didn't know i could do
this in access, thank you very much, that is what i was
looking for.

-----Original Message-----
Michael,

You can't do this with a macro. A change to the forecolor property
applies to all records in the form. You can achieve the desired
result by using Conditional Formatting (under the Format menu in the
form design window).

- Steve Schapel, Microsoft Access MVP

access 2000
i have a continuous form showing all records from a table.
i would like to make a certain feild look blank, but still
be able to access the data in that field if the field
equals zero. i have tried using macros to adjust the
forecolor to the same as the background color, however, it
changes the color for all the records based on which
record is current, not for each individual record. so if
the current record is zero, the specific field for all
records is "hidden". i have tried to run the macro in
different areas in the "events" of the form and fields,
not sure if i'm using the right event or if this is
possible using the events. any ideas on another method,
or something i'm doing wrong.

macro:
setvalue
item:[field].[forecolor]
expression[field]=0)*-12632256

.