Data type: Number, Field Size: Decimal, How do you declare it in VBDim statement?


S

Stapes

Hi

I have a field Quantity, defined in the Table Design as:
Dat Type: Number
Field Size: Decimal
Precision: 18
Scale: 3
Decimal Places: 3

How do I declare it in a VB Dim statement? (Visual Basic 6.3 - Access
2003).
It won't accept Dim quantity as decimal

Stapes
 
Ad

Advertisements

A

Allen Browne

Use a Variant.
You can coerce it to subtype decimal.

Example:
Dim varQty As Variant
varQty = CDec(5)
 

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

Top