cbyte() returns integer

  • Thread starter Thread starter bronson
  • Start date Start date
B

bronson

Hi,

I'm using a make-table query to create a table used as data source for a
report. In order to ensure the data types are correct, I use convert
functions in the make-table query. However, the data types in the created
table weren't what they were supposed to be. For example, I only got integers
where I used cbyte(), even though I couldn't figure out a single conversion
type error nor range violation (all values between 0 and 255). This problem
was encountered using Access 2003. Any thoughts on this anyone?

Thanks!

Bronson
 
Create a table with the data types you want.
Then use an Append query to populate it.
That's the only way to guarantee you get the table set up the way you want,
with the correct properties set on the fields (e.g. AllowZeroLength.)
 
Back
Top