By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,811 Members | 785 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,811 IT Pros & Developers. It's quick & easy.

Highlight full line in a Continuous Form !

P: n/a
Is there any EASY way to highlight a full row in a continuous form so
that as i navigate up & down the table/continuous form using the arrow
keys, the entire line (all fields) get highlighted ?

This will give the effect of a bar moving up & down. BTW, all fields
are locked so this form is View-Only & not editable.

Thx & Best Rgds,
Prakash.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Prakash,
For A2k and up try Conditional formatting. It's very easy.
You can change the background of all your controls in a row based on some expression.
e.g expression is : [Client_ID] = 1200
It's not really what you ask but this could 'look like' the entire line is highlighted.

--
Hope this helps
Arno R

"Prakash Wadhwani" <si****@omantel.net.om> schreef in bericht
news:60**************************@posting.google.c om...
Is there any EASY way to highlight a full row in a continuous form so
that as i navigate up & down the table/continuous form using the arrow
keys, the entire line (all fields) get highlighted ?

This will give the effect of a bar moving up & down. BTW, all fields
are locked so this form is View-Only & not editable.

Thx & Best Rgds,
Prakash.

Nov 12 '05 #2

P: n/a
See:
http://www.lebans.com/conditionalformatting.htm
A2K or Higher Only!

New Feb 08,2002. Added support for Datasheet view and SubForms.

A2KConditionalFormatting.zip is a sample MDB demonstrating how to
programmatically setup Conditional Formatting to simulate:

1) Highlighting of the Current Row for a Form in Continuous or Datasheet
View

2) Highlighting of Alternate Rows for a Form in Continuous or Datasheet
View

Version 2.7

Added sample demonstrating how to achieve a background
Hover/Highlighting of rows for a form in Continuous view.

Version 2.3

Added sample demonstrating how to achieve pseudo enable/disable of an
unbound control on a form in Continuous View.

Version 1.9

Added sample form to show how to apply conditional formatting to based
on a Boolean(Yes/No) field.

Verrsion 1.8
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Prakash Wadhwani" <si****@omantel.net.om> wrote in message
news:60**************************@posting.google.c om...
Is there any EASY way to highlight a full row in a continuous form so
that as i navigate up & down the table/continuous form using the arrow
keys, the entire line (all fields) get highlighted ?

This will give the effect of a bar moving up & down. BTW, all fields
are locked so this form is View-Only & not editable.

Thx & Best Rgds,
Prakash.


Nov 12 '05 #3

P: n/a
Hi Stephen ! Many thx for replying in such detail. I had perused the
NG & already downloaded your sample database before posting.
Unfortunately I don't know anything about classes & the code seems a
bit complex for me.

I was wondering if there was any EASIER way maybe using conditional
formatting (I'm using AXP) to change the backcolor of all the controls
on the curent row. This would provide that "bar-ish" effect I'm
looking for.

Now there's another problem ... this table does not have any pimary
key (it's from a legacy DbaseIII+ app) & as they are importing data
from it constantly, I cannot add my own primary key. But maybe by
referring to a combination of 3 to 4 fields I could come up with an
almost unique key.

How would I go about implementing this ?

Thx & Best Rgds,
Prakash.


"Stephen Lebans" <Fo****************************************@linval id.com> wrote in message news:<Sn********************@ursa-nb00s0.nbnet.nb.ca>...
See:
http://www.lebans.com/conditionalformatting.htm
A2K or Higher Only!

New Feb 08,2002. Added support for Datasheet view and SubForms.

A2KConditionalFormatting.zip is a sample MDB demonstrating how to
programmatically setup Conditional Formatting to simulate:

1) Highlighting of the Current Row for a Form in Continuous or Datasheet
View

2) Highlighting of Alternate Rows for a Form in Continuous or Datasheet
View

Version 2.7

Added sample demonstrating how to achieve a background
Hover/Highlighting of rows for a form in Continuous view.

Version 2.3

Added sample demonstrating how to achieve pseudo enable/disable of an
unbound control on a form in Continuous View.

Version 1.9

Added sample form to show how to apply conditional formatting to based
on a Boolean(Yes/No) field.

Verrsion 1.8
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Prakash Wadhwani" <si****@omantel.net.om> wrote in message
news:60**************************@posting.google.c om...
Is there any EASY way to highlight a full row in a continuous form so
that as i navigate up & down the table/continuous form using the arrow
keys, the entire line (all fields) get highlighted ?

This will give the effect of a bar moving up & down. BTW, all fields
are locked so this form is View-Only & not editable.

Thx & Best Rgds,
Prakash.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.