Results 1 to 4 of 4

Thread: text color

  1. #1
    Join Date
    Jun 2004

    Unanswered: text color

    I have a database where I have written VBA code to track changes that are made to the data in a form. The code I have is After Update and is as follows:

    Dim db as database
    Dim rs as recordset
    Set db = currentdb()
    Set rs = db.openrecordset("Select*from[tblRECORDCHANGES]")
    rs![Oldfield] = field.oldvalue
    rs![Newfield] = field.value
    rs![Date] = Now()

    My question is this. Can I make the [Newfield] = field.value put the info into the tblRECORDCHANGES in another color, i.e. red? If so, how would I do this in code?

  2. #2
    Join Date
    Mar 2004

    Lightbulb Colour field

    I think that it possible to see that in the form.
    Table is is object that handle your data and you cann't do that.

  3. #3
    Join Date
    Feb 2004
    Chicago, IL
    No. At the table level changes to the font (type, size and color) apply to all of the fileds in the table. So if you wanted all the fields in the table to be red then you can do that. But if you want to display it to the user then you can do it in a form. And you can make it look like a table if you want.

  4. #4
    Join Date
    Oct 2003
    You could also try playing with the conditional formatting. You can set multiple criteria and change the colour of the text and cell depending on your criteria.

    On the form, select the control, then select Format --> Conditional Formatting.

Posting Permissions

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