dblong data type mis match in Hide/Unhide columns in Ms Access VBA

[Mukt]

Hi
I have column with Number as data type. I want to hide this column using VBA coding.But in VBA coding we pass dblong as data type,so it is showing type mis matche. If i use number in place of dblong it showing error as conversion fail. Pls help

[zmbd]

You really have provided very little information.

Go back to your table.
Open in design mode.
Select the field in question.
In the field definition, you indicate that it is "Number" however, you fail to mention what type class that numeric field is, look down at the bottom of the UI. There will be a grid. In that grid you will have a tab named "General" and under that a row with title of "Field Size." I'd bet it is set to "Long Integer" change that to "Double."

If you have to have the result as an integer, then you will need to change the typecast in your VBA by using CLng

As a reference
VBA Conversion Functions (taken from the help file and other reference sources):

Function
 Return Type
 Range for expression argument
 
CBool
 Boolean
 Any valid string or numeric expression.
 
CByte
 Byte
 0 to 255.
 
CCur
 Currency
 -922,337,203,685,477.5808 to 922,337,203,685,477.5807.
 
CDate
 Date
 Any valid date expression.
 
CDbl
 Double
 -1.79769313486231E308 to -4.94065645841247E-324 for negative values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values.
 
CDec
 Decimal
 +/-79,228,162,514,264,337,593,543,950,335 for zero-scaled numbers, that is, numbers with no decimal places. For numbers with 28 decimal places, the range is +/-7.9228162514264337593543950335. The smallest possible non-zero number is 0.0000000000000000000000000001.
 
CInt
 Integer
 -32,768 to 32,767; fractions are rounded.
 
CLng
 Long
 -2,147,483,648 to 2,147,483,647; fractions are rounded.
 
CLngLng
 LongLong
 -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807; fractions are rounded. (Valid on 64-bit platforms only.)
 
CLngPtr
 LongPtr
 -2,147,483,648 to 2,147,483,647 on 32-bit systems, -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 on 64-bit systems; fractions are rounded for 32-bit and 64-bit systems. 
 
CSng
 Single
 -3.402823E38 to -1.401298E-45 for negative values; 1.401298E-45 to 3.402823E38 for positive values.
 
CStr
 String
 Returns for CStr depend on the expression argument.
 
CVar
 Variant
 Same range as Double for numerics. Same range as String for non-numerics.

[NeoPa]

The VBA equivalent of Double is dbDouble. Replacing dbLong with number could never work, obviously.

[zmbd]

Actually,
Re-reading OP
We startout with, "how to hide a coulmn?"
and end up with, "how to solve a type cast mismatch"

I really should have just closed the thread and asked OP to try and re-word the question.

Which is what I'll do after lunch if a clarification isn't posted by then by OP.