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 / General 1 / January 2006

Tip: Looking for answers? Try searching our database.

evaluating calculated controls

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kaosyeti@comcast.net - 28 Jan 2006 16:04 GMT
is there an easy way to evaluate a calculated control step by step?  i have a
lot of long expressions in a lot of my controls and if there's an error,
tracking it down is a PAIN.  excel has a built-in function for evaluating
formulas... does access?  thanks.
salad - 28 Jan 2006 16:29 GMT
> is there an easy way to evaluate a calculated control step by step?  i have a
> lot of long expressions in a lot of my controls and if there's an error,
> tracking it down is a PAIN.  excel has a built-in function for evaluating
> formulas... does access?  thanks.

I don't believe so.

You can use Debug.Print but I doubt that will help you.  That basically
returns the value of something.  Ex:
    Debug.Print Me.Text0

Instead of long expressions, you could create a function.  Let's say you
have the expression
    =IIF("A" = "B",True,False)
you could change the calculation to
    =CompAB("A","B")
Function CompAB(strA, strB) As Boolean
    If strA = strB Then CompAB = True
End Function

With the code window open, click to the right of Function CompAB.  This
will put a red dot to the left of it.  Now when this function is called
you can step through it and see what the values are that were passed to
the function and how they change as it is processed.
 
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.