Subform Cursor and Row Color

This question does not relate to the funtionality of my database, but I believe that it will increase the level of professionalism in the database's appearance.  I have numerous subforms, all in datasheet view, on which the user can select a record.  Currently, when the user clicks a record, the in text editor cursor shows up in the clicked column.  Is it possible to always have the traditional arrow cursor, and the selected record row will have a different color.  See the attached picture for a better understanding of what I am attempting to accomplish.
sfrmcursor.bmp
alliedtechAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If your form isn't editable, then just set all the Controls to Enabled=False ... this should give you what you want. You can set the BackColor using Conditional Formatting.

If your form is Editable, then why would you NOT allow the user to click where they want to begin their Text editing?

0
alliedtechAuthor Commented:
I apologize...my explanation was void of a few details.  I actually have a tab control with four pages.  Each page contains a subform to display records applicable to that page (In Process, Pending, Rejected, Awarded).  The user selects a record and then via several command buttons, the user can either view the record details (in a pop up form), or change the status of the bid (and then it will be included on a different page).  The user can not actually edit the data in the subforms.  Thanks for your solution!!
0
alliedtechAuthor Commented:
I set the subform data enabled property = NO and it succesfully removed the in text cursor just like I wanted.  However, I am having a few difficulties with the highlighting (perhaps I am using the wrong terminology).  I understand conditional formatting, but that is not my goal.  I want to click anywhere in the record's row and highlight that record(only one at a time).  If I click a new record, I want that one highlighted.  Currently, I must click on the record selector to the left of the record.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Unfortunately, if your controls aren't Enabled then you can really run code that would do this.

Try adding a Label (set the .Caption to a space), then select Format - Bring To Front. This might allow your to "activate" that record ...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
alliedtechAuthor Commented:
I have read several suggestions that recommend changing the form from datasheet to continuous, and then by altering the spacing etc, effectively creating a "datasheet view".   Does this by any chance change the capabilities of "highlighting" the selected record?
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
A form in Continuous View has more events available to it (since you have the entire Form and control event models to work with) so it could be beneficial. FWIW, I always use continuous forms since you have a much greater amount of control.
0
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.