Solved

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

Posted on 2014-12-04
8
649 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
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 23

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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

808 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