Show Bid Request Changing Data Type in Access Question Bid Request Id: 48543 Bookmark in my 'To Do' list Posted by: infomed (37 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 14.81% Buyer Security Verifications: Good Approved on: Feb 16, 2003 3:05:47 PM EDT Bidding Closes: Mar 2, 2003 3:05:25 PM EDT Viewed (by coders): 264 times Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Question or Beginner / Newbie Assistance Bidding Type: Open Auction Categories: Database, Language Specific, Visual Basic, Access Enter chat room for this bid request (2 active users at Sep 8, 2003 8:43:02 PM EDT) Description: 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: .Fields.Edit.EditField("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 Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   PeterJL (23 ratings) in Brisbane, Queensland Australia Bid id: 521,624   N/A Feb 16, 2003 7:37:03 PM EDT  9.57 (Excellent)     See attachment. Good luck Jon. This request reminded me that I had not rated you on our last job. I have rectified that, Thanks Attached File           There are 9 private replies to/from PeterJL. Click here to view them.