Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2015
    Posts
    51

    Question Unanswered: Back color if field is displaying default value? Or

    Is it possible to set a controls back color if it is using the default value and if the user changes the field, the color changes?

    Or is there another solution to this?

  2. #2
    Join Date
    Dec 2013
    Posts
    43
    Provided Answers: 1
    andromeda,

    I don't have Access right now, but this should get you started.

    You want to use Conditional Formatting (Defined in Design View). You'll want to use Expression.

    Expression: me.YourField.Default_Value = me.YourField

    If true, one color, if false use another color.

    hth,
    Wayne

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •