computer






 

Question by  susanfree (22)

Is it possible to change the control source of an unbound text box to calculate the sum in MS Access?

 
+5

Answer by  murali680 (559)

Yes, we can change the control source to get what we are looking to do. For this function we want to change the size of the box.

 
+3

Answer by  gigo (1706)

Write in the handler of the unbound text box the following line: =Sum([formname]![colname]). Whereby formname is the name your textbox is placed in and fiedname is the column to sum.

 
+1

Answer by  japratt (1687)

Yes, you can change the control source to get what your are looking to do. You will need to change the size of the text box for this function to work.

 
You have 50 words left!