change font color "fishqqq[ at ]hotmail.com" <fishqqq[ at ]hotmail.com> 11/26/2008 8:00:09 PM Is there a way to create a macro that would change the font color of a field from one color to another - but only in that field and only in that record? ie I have a macro that duplicates a record. in the new record i would like the [sellrate] field to be red font - which would flag the user to confirm the new sell rate for the new record. then i would create another macro that would change it back to the original color once the user double clicks the field. is this possible? tks Steve

Re: change font color "Ken Snell \(MVP\)" <kthsneisllis9[ at ]ncoomcastt.renaetl> 11/26/2008 10:17:10 PM Check out the SetValue action for macro. That also allows you to set a property for a control. -- Ken Snell <MS ACCESS MVP> http://www.accessmvp.com/KDSnell/ <fishqqq[ at ]hotmail.com> wrote in message news:a7a5c5c4-f2a3-43f1-bb25-4cc39d030e7b[ at ]l33g2000pri.googlegroups.com... [Quoted Text] > Is there a way to create a macro that would change the font color of a > field from one color to another - but only in that field and only in > that record? > > ie I have a macro that duplicates a record. > in the new record i would like the [sellrate] field to be red font - > which would flag the user to confirm the new sell rate for the new > record. then i would create another macro that would change it back to > the original color once the user double clicks the field. > > is this possible? > > tks > Steve