[AccessD]Highlightfieldbeingeditedinacontinuousform-in9simplesteps. -maybe too simple?

MarkH lists at theopg.com
Thu May 20 19:05:39 CDT 2004


Just tried it and it seems to work ok (using XP). I only did a simple
test though, I may give it a go with something more complex tomorrow...
I'm off to get some sleep...

Night night

Mark



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: 21 May 2004 00:51
To: Access Developers discussion and problem solving
Subject: RE:
[AccessD]Highlightfieldbeingeditedinacontinuousform-in9simplesteps.
-maybe too simple?


I've never been very happy with it, so I tend to fall back on other
methods.  It may work better in XP and 2003, but I haven't bothered to
try it.

Charlotte Foust

-----Original Message-----
From: MarkH [mailto:lists at theopg.com] 
Sent: Thursday, May 20, 2004 3:36 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD]
Highlightfieldbeingeditedinacontinuousform-in9simplesteps. - maybe too
simple?


Hehehe, nice one... Just realised how blinkered I am, despite sitting in
front of Access every day developing screens etc. I hadn't noticed the
conditional formatting option (maybe coz I never needed it, maybe coz
I'm getting on a bit). I must have looked straight at it thousands of
times... I need a holiday.

Cheers

Mark

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ken Ismert
Sent: 21 May 2004 00:23
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Highlight
fieldbeingeditedinacontinuousform-in9simplesteps. - maybe too simple?



I love it!!! Simple, no code, works in A2K. Great color flexibility.

Another method for highlighting the current field in A2K and later:

Select your form controls. Select Format, Conditional Formatting... in
the Condition 1 dropdown, select Field Has Focus, then set your
background and font style.

This method works in datasheet style forms, too. Sadly, checkboxes can't
have conditional formatting.

-Ken


-----Original Message-----
From: MarkH [mailto:lists at theopg.com]
Sent: Thursday, May 20, 2004 5:32 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Highlight field
beingeditedinacontinuousform-in9simplesteps. - maybe too simple?


No worries :@) That's what I thought initially. I did a simple form and
tried it out. Only the field in the current row that has the focus
changes colour. I don't recall if this is how previous versions of
Access behaved, but I do remember several years ago coming across the
same problem and, if I remember correctly, a similar solution to the one
mentioned earlier (the 9 steps bit). Only the control with the focus
changes colour, not all of the ones in the same row or column...

Mark
PS - my memories clearing a bit... The problem I came across before was
how to make alternate rows in a continuous form different colours. The
solution looked similar, no idea where I saw it though.

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list