INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Stop datasheet using alternate colours

Stop datasheet using alternate colours

(OP)
Trying to stop a datasheeet subform from giving selected row a blue colour, except for cell with focus.

Tried design view / detail / changing Back Color and Alternate Back Color but the selected row remains blue in form view.

RE: Stop datasheet using alternate colours

Don't know your version, but in v2007 you go to Options - Datasheet and set the Alternate Back Color to 'No Color.'

The caveat, here, is that you have to do this before creating the Datasheet View Form! Doing it doesn't change the appearance of previously created forms.

Hope this helps!

There's always more than one way to skin a cat!

All posts/responses based on Access 2003/2007

RE: Stop datasheet using alternate colours

(OP)
I assume the equivalent in my later version is to go to Design View / select Detail / Format tab / Alternate Row Color. But changing this doesn't get rid of the light blue colour on selecting a record, even when creating a new test form in datasheet view.

Thanks for your suggestion though.

RE: Stop datasheet using alternate colours

Sorry...misunderstood your question! Don't think you can do away with the current/selected Record being hi-lighted, in Datasheet View. To be honest, can't imagine why you'd want to! But everybody has different needs!

As is often the case, when wanting something that looks like a Datasheet, but behaves differently than a Datasheet, I think you need to use a Continuous View Form and tweak it to look like a Datasheet. Moving from Record to Record, on this kind of setup, would not change the color of the selected row.

Linq ;0)>


Hope this helps!

There's always more than one way to skin a cat!

All posts/responses based on Access 2003/2007

RE: Stop datasheet using alternate colours

(OP)
Thanks for this, another line of pursuit.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close