If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Highlighting one row in a continuous form?
How can I highlight one row in a continuous form? I have a checkbox at the
end of the row, and if it is checked I want that row to change colour. If I do that, every row on the form changes colour - not just the one I wanted to change. Is there a way to do this? Thanks, Nick |
#2
|
|||
|
|||
Highlighting one row in a continuous form?
Hi Nick,
You can do what you want by using the form & subform paradigm and by showing the form in the subform control in Form View, not Datasheet View. You can do that by designing the form to be only as tall as the text or other controls on it. HTH -- -Larry- -- "Nick" wrote in message ... How can I highlight one row in a continuous form? I have a checkbox at the end of the row, and if it is checked I want that row to change colour. If I do that, every row on the form changes colour - not just the one I wanted to change. Is there a way to do this? Thanks, Nick |
#3
|
|||
|
|||
Highlighting one row in a continuous form?
Hi - Thanks for the reply. The problem is that I want to be able to see more
than one row at a time, but only highlight the rows that the tickbox is checked. Nick "Larry Daugherty" wrote in message ... Hi Nick, You can do what you want by using the form & subform paradigm and by showing the form in the subform control in Form View, not Datasheet View. You can do that by designing the form to be only as tall as the text or other controls on it. HTH -- -Larry- -- "Nick" wrote in message ... How can I highlight one row in a continuous form? I have a checkbox at the end of the row, and if it is checked I want that row to change colour. If I do that, every row on the form changes colour - not just the one I wanted to change. Is there a way to do this? Thanks, Nick |
#4
|
|||
|
|||
Highlighting one row in a continuous form?
You would have to use ConditionalFormatting available with A2K or
higher. See: http://www.lebans.com/toc.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. "Nick" wrote in message ... Hi - Thanks for the reply. The problem is that I want to be able to see more than one row at a time, but only highlight the rows that the tickbox is checked. Nick "Larry Daugherty" wrote in message ... Hi Nick, You can do what you want by using the form & subform paradigm and by showing the form in the subform control in Form View, not Datasheet View. You can do that by designing the form to be only as tall as the text or other controls on it. HTH -- -Larry- -- "Nick" wrote in message ... How can I highlight one row in a continuous form? I have a checkbox at the end of the row, and if it is checked I want that row to change colour. If I do that, every row on the form changes colour - not just the one I wanted to change. Is there a way to do this? Thanks, Nick |
#5
|
|||
|
|||
Highlighting one row in a continuous form?
Using the method I suggested, you can. Be sure to set the default view of
the subform to continuous. -- -Larry- -- "Nick" wrote in message ... Hi - Thanks for the reply. The problem is that I want to be able to see more than one row at a time, but only highlight the rows that the tickbox is checked. Nick "Larry Daugherty" wrote in message ... Hi Nick, You can do what you want by using the form & subform paradigm and by showing the form in the subform control in Form View, not Datasheet View. You can do that by designing the form to be only as tall as the text or other controls on it. HTH -- -Larry- -- "Nick" wrote in message ... How can I highlight one row in a continuous form? I have a checkbox at the end of the row, and if it is checked I want that row to change colour. If I do that, every row on the form changes colour - not just the one I wanted to change. Is there a way to do this? Thanks, Nick |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Highlighting individual records on a continuous form | Dave | General Discussion | 2 | July 1st, 2004 09:31 AM |
Continuous Form | Doua | General Discussion | 1 | June 21st, 2004 06:46 PM |
only in vertical on continuous form? | joanu | Using Forms | 3 | June 11th, 2004 12:00 AM |
Continuous form requery | Randy Harris | New Users | 0 | May 25th, 2004 10:25 PM |
Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |