Changing Data Type in Access Question

Lengkap Disiarkan Feb 16, 2003 Dibayar semasa penghantaran
Lengkap Dibayar semasa penghantaran

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

Kejuruteraan Microsoft Access MySQL PHP Kejuruteraan Perisian Ujian Perisian Visual Basic

ID Projek: #2907646

Tentang projek

10 cadangan Projek jarak jauh Aktif Feb 17, 2003

Dianugerahkan kepada:

peterjl

See private message.

$9 USD dalam 14 hari
(75 Ulasan)
5.3

10 pekerja bebas membida secara purata $14 untuk pekerjaan ini

danvlas

See private message.

$5.1 USD dalam 14 hari
(75 Ulasan)
5.6
vw706184vw

See private message.

$8.5 USD dalam 14 hari
(89 Ulasan)
5.7
cgessler

See private message.

$8.5 USD dalam 14 hari
(6 Ulasan)
3.3
infinitivw

See private message.

$17 USD dalam 14 hari
(7 Ulasan)
2.5
vw592411vw

See private message.

$3.4 USD dalam 14 hari
(4 Ulasan)
0.3
gorancovw

See private message.

$17 USD dalam 14 hari
(0 Ulasan)
0.0
mcp111

See private message.

$42.5 USD dalam 14 hari
(2 Ulasan)
0.0
djohnsonvw

See private message.

$21.25 USD dalam 14 hari
(0 Ulasan)
0.0
goldeneyevw

See private message.

$4.25 USD dalam 14 hari
(0 Ulasan)
0.0