Trouble with VB script on a Form

[barien75]

For some reason when run this I get an error. It seems to be when it hits the rounding function as when I comment it out it works fine. Any ideas what I am doing wrong?

 

[jdraw]

Try
SqFtR= Round(SqFt, 4)

 

[Pat Hartman]

[4 as Long] is undefined

 

[barien75]

Try
SqFtR= Round(SqFt, 4)

Totally strange, I had tried that and Access wasn't allowing me to do that. Now if enter that it works.

 

[Pat Hartman]

Just FYI - VB Script is different from VBA. In Access and the other Office products, the internal language is VBA. VBA is an embedded language and is customized with the objects of the application it is intended to support. VB Script is more like a batch language used outside of Office products.