Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / February 2007

Tip: Looking for answers? Try searching our database.

Displaying specific columns on a continuous style form`

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cameron - 28 Feb 2007 16:59 GMT
Is there a way to code a continuous style form so that specific records in
the list will trigger other records to either be visible or not as the rows
build down the form?

I have two examples where I need to selectively highlight textboxes on a
continuous style form but have only been successful in either having those
textboxes be either on or off.
Damon Heron - 28 Feb 2007 19:01 GMT
Are you asking about conditional formatting of certain textboxes based on
their value?  If so, use the conditional formatting routine.  If not, could
you explain further what you are trying to accomplish?

Damon

> Is there a way to code a continuous style form so that specific records in
> the list will trigger other records to either be visible or not as the
[quoted text clipped - 4 lines]
> continuous style form but have only been successful in either having those
> textboxes be either on or off.
Cameron - 28 Feb 2007 19:21 GMT
Conditional Formatting?

Basically, I have a Continuous style form that has text boxes on it. The
user enters specific criteria in one of those boxes and based on that
criteria another text box hides or shows on the form. However, if this where
to be a new record the hidden text box might not need to be seen.

So would the conditional formating routine still work with this situation?

> Are you asking about conditional formatting of certain textboxes based on
> their value?  If so, use the conditional formatting routine.  If not, could
[quoted text clipped - 10 lines]
> > continuous style form but have only been successful in either having those
> > textboxes be either on or off.
Damon Heron - 28 Feb 2007 20:13 GMT
With conditional formatting, by creating an expression,  you can change the
formatting and disable a textbox based on the value in another textbox, but
you can't hide it.  That is a limitation of continuous forms.  With a
regular form, you could put visible properties in the Current event as the
user goes thru the records.

Damon

> Conditional Formatting?
>
[quoted text clipped - 24 lines]
>> > those
>> > textboxes be either on or off.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.