T TBC Registered User. Local time Today, 02:34 Joined Dec 6, 2010 Messages 145 Jun 3, 2015 #1 Can someone please help me? I need to convert a numbers column in an access table to a text format
Uncle Gizmo Nifty Access Guy Staff member Local time Today, 10:34 Joined Jul 9, 2003 Messages 17,358 Jun 3, 2015 #2 You should be able to do it in the table design view it should work fine without any problems however you must back up before you do it!
You should be able to do it in the table design view it should work fine without any problems however you must back up before you do it!
V vbaInet AWF VIP Local time Today, 10:34 Joined Jan 22, 2010 Messages 26,374 Jun 3, 2015 #3 ... and remove the relationships between any parent/child table(s) before you perform this conversion, then re-link them back. Again on a backup like Uncle G exclaimed.
... and remove the relationships between any parent/child table(s) before you perform this conversion, then re-link them back. Again on a backup like Uncle G exclaimed.
The_Doc_Man Immoderate Moderator Staff member Local time Today, 04:34 Joined Feb 28, 2001 Messages 30,038 Jun 4, 2015 #4 Alternate view: Don't convert them. Build a query that does a particular type of formatting and use that in place of the table.
Alternate view: Don't convert them. Build a query that does a particular type of formatting and use that in place of the table.