Web Development

Ask something
Discussion Locked

math calculations in forms

0 helpful
1 reply

by cd101

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm working on an online form for a client. The user will be entering dollar amounts and the client wants the form to be able to total those dollar amounts up. I'm sure there is a way to do it, but I have no clue how to do this. Does anyone have any advice? Thanks.

1 reply

by hardtymes3408

If you are using a text box on your form it is really very simple. Make sure the Option Explicit is enabled in your vb and (dim sngMoney as single) would be the first order of business.
Then the rest is pretty easy.
sngMoney = val(text1.TEXT + text2.TEXT +_ text3.Text)
The currency option in vb works well also!
This is using text boxes of course on your form.
You can alway make sure and format the way you want it to look also when the client wants it a certain way. Hope this helps

This discussion is closed to new replies.