How to change database field type

's Computer Specifications

I have a field in my Access database set up through the wizard as integer and
I need to change it to text. How can ths be done?
--
Thanks

's Computer Specifications

Open the database in Access and change it.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"SoccerBoy" <(E-Mail Removed)> wrote in message
news:B65DDD64-8AD4-47A5-9F6A-(E-Mail Removed)...
>I have a field in my Access database set up through the wizard as integer and
> I need to change it to text. How can ths be done?
> --
> Thanks

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Finding Field Type and Length in a SQL Database	Brian	Microsoft Access Form Coding	3	7th Oct 2008 02:49 AM
You can't change the data type or field size of this field error.	=?Utf-8?B?TWVsYW5pZQ==?=	Microsoft Access	2	3rd Aug 2007 03:08 PM
Chnage Field Type in another database	=?Utf-8?B?U2FyYWg=?=	Microsoft Access Form Coding	0	6th Oct 2006 04:46 PM
Change Field Data Type in a table in another database	=?Utf-8?B?U2FyYWg=?=	Microsoft Access Form Coding	0	5th Oct 2006 07:30 PM
Programmatically change a field of number type to text type	GVR_Mike	Microsoft Access	1	13th Jun 2006 04:20 AM