Results 1 to 2 of 2
  1. #1
    StanleyB is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jul 2010
    Location
    New York
    Posts
    2

    Best practice for using calculated controls on a form

    What would be the best practice for using calculated controls on an Access form? I have a form that has 8+ bound text boxes and 20+ unbound text boxes that populate using misc. calculations based on values in the bound text boxes. Current I'm using UDF's as the data sources for the unbound text boxes, but am wondering if using classes would be a better approach where class properties would be used to populate the controls instead. Any advise based on past experience would be greatly appreciated.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,932
    Without knowing what your calculations are, not really possible to provide a definitive answer

    depends on your calculations but your probably don't need to use udf's, just type the calculation into the controlsource. With regard class properties I have never had a need to use them in this way, I doubt there would be an improvement in performance.

    Please note I will be away from the forum for a couple of weeks so not in a position to respond further

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Best practice - Form design
    By les@wilcock.plus.com in forum Forms
    Replies: 1
    Last Post: 01-02-2015, 05:57 PM
  2. Replies: 10
    Last Post: 11-08-2014, 07:28 PM
  3. Please help-problem with calculated controls
    By anfontan in forum Access
    Replies: 4
    Last Post: 11-24-2013, 09:38 PM
  4. Calculated Controls for Data Entry
    By Monterey_Manzer in forum Forms
    Replies: 3
    Last Post: 06-29-2012, 02:39 PM
  5. Help with calculated controls
    By DannyV in forum Forms
    Replies: 2
    Last Post: 04-20-2010, 12:07 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums