[AccessD]Highlightfieldbeingeditedinacontinuousform-hmmmmm worksfor me matey

Scott Marcus marcus at tsstech.com
Mon May 24 13:42:43 CDT 2004


Mark,

It changes the color of the controls to that of the background. This introduces more work to get them to look like they normally appear when not set to transparent. So for me to say that it doesn't work, isn't entirely true. It just doesn't work the way I want it to work. 

Scott Marcus
TSS Technologies, Inc.
marcus at tsstech.com
(513) 772-7000

 -----Original Message-----
From: 	accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]  On Behalf Of MarkH
Sent:	Monday, May 24, 2004 2:37 PM
To:	'Access Developers discussion and problem solving'
Subject:	RE: [AccessD]Highlightfieldbeingeditedinacontinuousform-hmmmmm worksfor me matey

Scott...

I just tried the first solution I offered in Access 97 and it works just
fine. Just set a background colour (different to the forms background
colour), then make the back style transparent and make sure the subform
is set to continuos not datasheet. 

As mentioned by Charlotte, this only provides field highlighting not row
highlighting, as can be achieved with conditional formatting in XP etc.
Whichever field has the focus has its background made visible by access
until it loses the focus...

Second point... Sorry I missed the start of the thread, I'm not even
sure who started it, good luck whoever you are :@) didn't mean to spark
anything off, was just having a bit of fun as I was bored... It can be
very frustrating having your hands tied by the limitations of a clients
setup. I'm sure you will be making the most of whats available,
particularly through subscribing to this very informative list.

All the best

Mark

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Scott Marcus
Sent: 24 May 2004 14:19
To: Access Developers discussion and problem solving
Subject: RE:
[AccessD]Highlightfieldbeingeditedinacontinuousform-in9simplesteps.-mayb
etoosimple?


Ken,

Highlighting individual fields on a continuous form in Acc97 requires
coding when the continuous form is a sub form. The solution Mark gave
doesn't work for Acc97.

I'm sorry that you aren't interested in the solution for check boxes.
The "...- in 9 simple steps " is a continuation of an earlier post. As a
courtesy to those who helped me, I provide the solution steps I took.
These steps are then kept in the archive so that others may search for
the solution later (including myself).

I hate to be crass(and wouldn't normally reply to your comments), but
look at the context of a solution before you knock it. I'm just trying
to provide a polished interface for my end user given the constraints of
the hardware and software on their machine.

Scott Marcus

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