Record selection color

[dbprogman]

Hi all

I have a datasheet and when a user selects a record that record is highlighted by a dull colour (default) I wish to change this colour to a more prominent one, the simple question is how?

Access 2007

Thanks for your assistance.

 

[vbaInet]

Please avoid double-posting. We can see all sections of the forum. Your question is related to Forms and should be in this section, not in the Modules & VBA section as you've done here:

http://www.access-programmers.co.uk/forums/showthread.php?t=206478

I'm guessing you're talking about pre Access 2007. If that is so, then it can't be done. There may be an API that allows you to use the form's hWnd to get and set those properties.

 

[dbprogman]

I am using Access 2007 and simply just want to change the highlight color when a record is selected. I am sorry about the double post was a little unsure as to which category... Wont happen again.

 

[vbaInet]

It can't be done unfortunately. I only said pre 2007 because the colour is black but in 2007 I don't mind the highlight colour. As previously mentioned, an API (just) might be the only way, so have a look on the net.

 

[dbprogman]

ok thanks for the reply...