Adjusting Table Column Field Width from VB

[BigJimSlade]

Hello, Big Jim here:

I created an Access table using code (tableDef, field, etc.).

I am trying to adjust the field width of a table's column from code. Any suggestions?

Thanks in advance!

Big Jim

 

[MHM]

Hey Big Jim,

if you've got enough Big experience with Access - as I assume, Jim - you never let customers or all-day-users get to tables. You'll always keep them at forms or reports - so set table column widths in your forms.

Mic

 

[BigJimSlade]

Thanks, Mic, that is a very good point.

Big Jim just lets his boss look at the table, but I'll look into that Form idea as well.

I use the table as a report. The table is not referenced by anything, and it doesn't look like it would fit in a report nicely. I'll email you a piece of it if you would like to look at it and give me your input. I appreciate your help!


Thanks,

Big Jim