Table FieldName = 0# - Does the # mean DOUBLE WITH A VALUE OF ZERO?

**maxis** · 02-07-2018, 12:10 PM

I don’t think I’ve ever seen this VBA syntax before and my google searches haven’t provided an answer. VBA code in MS Access where the right side is = 0#. What does the # do? Guessing it might mean DOUBLE field type, but I would sure appreciate a definitive answer please. Thanks...

**isladogs** · 02-07-2018, 12:14 PM

Using a # sign is an old syntax which forces the datatype to be a double.

This recent thread at another forum will explain in more detail: https://www.access-programmers.co.uk...d.php?t=298075

**maxis** · 02-07-2018, 12:23 PM

Awh... so it is! This database is over 15 years old so that makes sense! THANK YOU SO MUCH!

**isladogs** · 02-07-2018, 01:12 PM

You're welcome
I've been using Access for almost 20 years & have never used this type of syntax myself

**Missinglinq** · 02-07-2018, 02:57 PM

Originally Posted by ridders52

You're welcome
I've been using Access for almost 20 years & have never used this type of syntax myself

That is a blast from the past! It really goes back to QuickBasic, which VBA was originally based on.

Linq ;0)>

Table FieldName = 0# - Does the # mean DOUBLE WITH A VALUE OF ZERO?

Thread Tools

Table FieldName = 0# - Does the # mean DOUBLE WITH A VALUE OF ZERO?

Similar Threads

Select Query Parameter: How to Look Up a FieldName that is equal to a Form Entry?

Deleting double quotes out of my table?

If check box is checked double the amount entered into table

How to reference a fieldname with a variable in DAO's rs!FieldName syntax

What is the Access version of Count(Distinct(fieldname))?

Posting Permissions