Results 1 to 9 of 9
  1. #1
    Join Date
    Oct 2003
    Posts
    10

    Question Unanswered: Highlighting rows in Datasheet view

    Is it possible to change the forecolor, or backcolor of a record in datasheet view if the record meets certain criteria?


    Thanks Ron

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    In a continus form can do it
    Saludos
    Norberto

  3. #3
    Join Date
    Aug 2003
    Location
    Belgrade
    Posts
    68

    Re: Highlighting rows in Datasheet view

    I had recently a similar problem and as it seems, there is no way to change any setting of an individual row or cell in a datasheet.

    The only workaraound I found was to use a tabular continuous form and to set its controls to mimic as closely as possible a datasheet. The result is a bit ugly, and you can't freeze columns, but otherwise it works.

  4. #4
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    If you want i post and sample from Microsoft of that topic.
    ok
    Saludos
    Norberto

  5. #5
    Join Date
    Oct 2003
    Location
    US
    Posts
    343
    Well I'm interested in seeing if we can change the background colors of a datasheet or continuous form. Please post your solution.

    Originally posted by Norberto
    If you want i post and sample from Microsoft of that topic.
    ok

  6. #6
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    khan:
    I do it.
    Attached Files Attached Files
    Saludos
    Norberto

  7. #7
    Join Date
    Oct 2003
    Posts
    10
    That is definately useful, but I would need to do something like the following:

    Set ForeColor = Red for all records that have UnitsInStock < 1.

    Unfortanetly I don't know if I would be able to do that

  8. #8
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    rongiul :
    You can do it.
    Study the code of the sample.zip , see what function use, we talk
    about of contiuos forms.
    Is not easy but can do it.
    Saludos
    Norberto

  9. #9
    Join Date
    Oct 2003
    Posts
    10
    Thanks for the encouragement , and I did find a solution. This is what I did:

    for each field I created 2 textboxes, 1 with red ForeColor and 1 with black ForeColor. I'll use field [ProductName] only but all other fields are similar.

    Conrtol Source for Red font = IIf([UnitsInStock]<2,[ProductName],Null)


    Conrtol Source for Black font =IIf([UnitsInStock]>=2,[ProductName],Null).


    This did the trick for me. If there is an alternate way please let me know.

    Thanks for the posts

    Ron

Posting Permissions

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