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 / Modules / DAO / VBA / October 2007

Tip: Looking for answers? Try searching our database.

Hide content of unbound text box from non-current records

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brian - 06 Oct 2007 17:36 GMT
Continuous form. I have three controls in question here:

TimeBegin (unbound)
TimeEnd (unbound)
TimeCount

On TimeBegin & TimeEnd AfterUpdate events, this code (over-simplified here):

TimeCount = TimeEnd - TimeBegin
TimeBegin = Null
TimeEnd = Null

How can I hide the contents of TimeBegin & TimeEnd from all except the
current record? Conditional format with white font? But if so, how do I
determine the record number for the non-current records? Or is there some
simpler way?
Alex Dybenko - 06 Oct 2007 19:38 GMT
Hi,
perhaps this will help:
http://www.lebans.com/conditionalformatting.htm

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

> Continuous form. I have three controls in question here:
>
[quoted text clipped - 13 lines]
> determine the record number for the non-current records? Or is there some
> simpler way?
Brian - 06 Oct 2007 19:49 GMT
That did it. Thanks, Alex.

> Hi,
> perhaps this will help:
[quoted text clipped - 17 lines]
> > determine the record number for the non-current records? Or is there some
> > simpler way?
 
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.