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

Continuous forms, highlighting specific record

P: n/a
Hi there, I have a subform, set as a continuous form.
When a user selects a particular record in that subform, how can I make that
particular record stand out (color or font change, size, etc) from
the other records in the list?
Thank you in advance,
Mark
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
You might be able to do something using Conditional Formatting on the Format
menu in design view.
I think you'll have to set the conditional formatting individually for each
control, however.

HTH
- Turtle

"Mark" <mv*****@hotmail.com> wrote in message
news:10*************@corp.supernews.com...
Hi there, I have a subform, set as a continuous form.
When a user selects a particular record in that subform, how can I make that particular record stand out (color or font change, size, etc) from
the other records in the list?
Thank you in advance,
Mark

Nov 12 '05 #2

P: n/a
Thanks a bunch. I'd never used conditional formatting and it will help,
although I still need, if possible, to "flag" the whole record.
Thank you very much.


"MacDermott" <ma********@nospam.com> wrote in message
news:8F*****************@newsread1.news.atl.earthl ink.net...
You might be able to do something using Conditional Formatting on the Format menu in design view.
I think you'll have to set the conditional formatting individually for each control, however.

HTH
- Turtle

"Mark" <mv*****@hotmail.com> wrote in message
news:10*************@corp.supernews.com...
Hi there, I have a subform, set as a continuous form.
When a user selects a particular record in that subform, how can I make

that
particular record stand out (color or font change, size, etc) from
the other records in the list?
Thank you in advance,
Mark


Nov 12 '05 #3

P: n/a
For sample code see:
http://www.lebans.com/conditionalformatting.htm
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.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Mark" <mv*****@hotmail.com> wrote in message
news:10*************@corp.supernews.com...
Thanks a bunch. I'd never used conditional formatting and it will help, although I still need, if possible, to "flag" the whole record.
Thank you very much.


"MacDermott" <ma********@nospam.com> wrote in message
news:8F*****************@newsread1.news.atl.earthl ink.net...
You might be able to do something using Conditional Formatting on the
Format
menu in design view.
I think you'll have to set the conditional formatting individually
for each
control, however.

HTH
- Turtle

"Mark" <mv*****@hotmail.com> wrote in message
news:10*************@corp.supernews.com...
Hi there, I have a subform, set as a continuous form.
When a user selects a particular record in that subform, how can I

make that
particular record stand out (color or font change, size, etc) from
the other records in the list?
Thank you in advance,
Mark




Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.