Changing Data Type in Access Question

Completed Posted Feb 16, 2003 Paid on delivery
Completed Paid on delivery

I've got an Access 2000 db that has a field in it called ChartID. This field was previously set up as a Number data type. I want to change it through VB code to be a text data using code something like this: .[login to view URL]("ChartID", dbText, 30) 'these commands aren't right. This is the sort of command I'm trying to figure out... .Fields("ChartID").Required = False .Fields("ChartID").AllowZeroLength = True Is there anyway to do this?? Thanks for the free advice!

## Deliverables

code to do this

## Platform

win

Engineering Microsoft Access MySQL PHP Software Architecture Software Testing Visual Basic

Project ID: #2907646

About the project

10 proposals Remote project Active Feb 17, 2003

Awarded to:

peterjl

See private message.

$9 USD in 14 days
(75 Reviews)
5.3

10 freelancers are bidding on average $14 for this job

danvlas

See private message.

$5.1 USD in 14 days
(75 Reviews)
5.6
vw706184vw

See private message.

$8.5 USD in 14 days
(89 Reviews)
5.7
cgessler

See private message.

$8.5 USD in 14 days
(6 Reviews)
3.3
infinitivw

See private message.

$17 USD in 14 days
(7 Reviews)
2.5
vw592411vw

See private message.

$3.4 USD in 14 days
(4 Reviews)
0.3
gorancovw

See private message.

$17 USD in 14 days
(0 Reviews)
0.0
mcp111

See private message.

$42.5 USD in 14 days
(2 Reviews)
0.0
djohnsonvw

See private message.

$21.25 USD in 14 days
(0 Reviews)
0.0
goldeneyevw

See private message.

$4.25 USD in 14 days
(0 Reviews)
0.0