[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

MS Access: How to highlight rows in continuous forms without the form content “jumping” ?

Posted on 2014-12-04
8
Medium Priority
?
1,060 Views
Last Modified: 2014-12-05
Helo,

I am using Access 2013, and have a continuous form on which I want to highlight the selected row. I have it working using the solution described here: http://answers.microsoft.com/en-us/office/forum/office_2007-access/highlight-row-in-continuous-form/a862821f-ebee-4ebc-93d9-e068debcab84.
To summarize:
1.      the form controls have been made transparent and placed on top of a long textbox.
2.      An invisible text box (named txtCurrent) is placed in the form header. This has its value set to the primary key field in the form’s Current event: Me.txtCurrent = Me.[primary key field]
3.      The long textbox has been conditionally formatted using the Expression Is option: [primary key field] = [txtCurrent]
…and its background set to the desired highlight color.

However, I find that every time a new row is selected, the form content “jumps” quite noticeably. I am not sure why this is, but does anyone know of an alternative way to highlight rows without the form content jumping every time ? Sorry to be finicky ! I have searched quite a bit for a way to solve this, but couldn’t find anything. Thank you advance for any help.
0
Comment
Question by:Paul McCabe
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40482211
did you try setting the Detail's Back color and Alternate Back color property>
0
 

Author Comment

by:Paul McCabe
ID: 40482236
Thank you for your response. Do you mean having the rows display "permanently" in alternate colors, as opposed to a row being highlighted when selected ?
0
 
LVL 24

Expert Comment

by:Eirman
ID: 40482473
I haven't read right through the method you were using and the one described here
http://www.upsizing.co.uk/Art53_Highlight.aspx
but they both look very similar.

The latter one mentions a flicker in Access 2003 that was fixed by an SP update.
Perhaps Access 2013 needs a similar fix.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Author Comment

by:Paul McCabe
ID: 40482603
I am using Windows 7, with the latest Servce Pack (SP1) installed.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 1000 total points
ID: 40482726
Here is an Oldie but a Goodie:
http://www.lebans.com/conditionalformatting.htm

FWIW, I stopped doing things like this a while ago.
All the coding and design modifications were not really worth it.

...Besides, ..none of these mods really worked as smoothly as I expected.
In the end, I removed this and no one cared, ...

JeffCoachman
0
 
LVL 31

Assisted Solution

by:Helen Feddema
Helen Feddema earned 1000 total points
ID: 40483332
Here is an Access Archon article I did a while back that describes how to highlight the selected row in a CF form:

http://www.helenfeddema.com/Files/accarch173.zip

Here is a screen shot of the form:

Current row back colorIt doesn't cause jumping, at least on my computer.
0
 

Author Comment

by:Paul McCabe
ID: 40483417
Thank you all very much for your comments and suggestions. I will revert as soon as I have managed to test these out.
0
 

Author Comment

by:Paul McCabe
ID: 40484158
I resolved the jumping screen issue by adding a check box to the record, and making the long text box highlight dependant on the check box value being True. The checkbox needs to be clicked/unclicked to highlight/un-highlight records, but this is fine for the intended use, and has the advantage that multiple records can be highlighted simultaneously. Many thanks for pointing me towards a solution !

FYI: Interestingly, no method that requires associating the primary key with conditional formatting via a third control resolves the issue. The examples you sent seem to have been created in earlier versions of Access, so maybe the jumping screen phenomenon that I see using these methods is specific to Access 2013.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question