BigInt, ADP (Access 2000 file format) & SQL Server 2005

[Sara4]

I created an ADP that points to a SQL Server 2005. I use a BigInt columns in
a couple of tables. I haven't been able to format these columns (clicking on
property Format in ADP for the column I don't get the list of the formats
(General Number, Currency, Standard...).
Any ideas why this happens? Any ideas how to solve the problem?

 

[Tom van Stiphout]

On Tue, 11 Dec 2007 07:55:01 -0800, Sara4

Idea: write your own format expression. See the help file on Format >
Numeric formats.

-Tom.

 

[Sara4]

What are you reffering to when you say Help file and Format > Numeric Format?
Access Help? Didn't find it...