Clearing Values of Variables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a procedure that calculates values of fields - I need to clear the
contents of the variables (currency and string data type). What is the best
way to do this? I have tried:

curCCCharge = null

I keep having problems with this ("invalid use of null")

Thanks in advance for your help.
 
For the currency type, you will need to use 0 and for the string use "" or
vbNullString
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clear Global Variable 2
Null variable values? 5
How to Change Value of Active Control 5
How to create a bubble chart with more than 2 variables 0
sorting: cleared/null v/s "" 3
Can i build a property to set NULL value for a control? 4
public variable 4
VBA: How can I use a string variable as autofilter criteria? 4

Back
Top