472,958 Members | 2,143 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,958 software developers and data experts.

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 7822
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
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
2
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

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.