473,473 Members | 1,902 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Continuous forms, highlighting specific record

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
3 7876
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: David | last post by:
Hi, I need a button shown for each record (cont. form) with specific captions on each. I have a notes form for each record. When a user presses the button they can read the notes. I want to...
4
by: Bob Alston | last post by:
I have some dates which show in a continuous form, multiple rows at a time. I would like to color the background yellow, or the text yellow or some color other than black that would stand out,...
5
by: Armando | last post by:
I recently saw the tail end of a "Continuous forms" discussion, but not enough was available to see if this will be a PITA repeat question. Sorry if it is. On a form with its Default View...
4
by: Kathy | last post by:
What is the standard technique for handling the fields in the following scenario on a continuous form? Multiple Divisions. Each Division has multiple Buildings. Each Building has a Supervisor. ...
2
by: ThompsonJessical | last post by:
I am trying to use a button with the vba coding for SendObject Function to email a specific report based on the value of another field of the current record. The form is a continuous form and...
9
by: Edwinah63 | last post by:
Hi everyone, Please let there be someone out there who can help. I have two BOUND combo boxes on a continuous form, the second being dependent on the first. I have no problem getting the...
1
by: kaeldowdy | last post by:
This one is stumping me! I have a Form/Subform arrangement. The main form is set as a Single Form and the sub form is set as Continuous Forms. On the Form_AfterUpdate event of the subform, I...
3
by: RAG2007 | last post by:
I have a subform that is set in continuous form view. My VBA code fills in specific values in unbound fields on each form in the "On Current" event. The values are dependent on other fields in the...
7
by: Dave | last post by:
Hello All, These one may be a bit tricky, and what I'd like to do may not even be possible. I would love to hear any ideas you guys have for solving this. Here is the situation: I have a form...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.