[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 885
  • Last Modified:

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
0
alliedtech
Asked:
alliedtech
  • 3
  • 3
1 Solution
 
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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
 
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now