visibility

  • Thread starter Thread starter Michael
  • Start date Start date
M

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
 
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
 
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
Click to expand...

.
Click to expand...
 
Back
Top