HELP

  • Thread starter Thread starter DAN
  • Start date Start date
As far as I know, no, there isn't.

But if you are using Access 2000 or above, you could use this code

Sub Numeric2Text(tblName As String, fldName As String)
Dim strSQL As String

strSQL = "ALTER TABLE " & tblName _
& " ALTER COLUMN " & fldName & " TEXT"

CurrentDb.Execute strSQL, 128 'dbFailOnError

End Sub

HTH

--
Saludos desde Barcelona
Juan M. Afan de Ribera
<MVP Ms Access>
http://www.juanmafan.tk
http://www.clikear.com/webs4/juanmafan
 
Either Str() or CStr() depending on your number types. Check
them out in Help.

Gary Miller
Sisters, OR
 
On Fri, 31 Oct 2003 14:06:47 -0800, "DAN"

Dan,

Most people who post here want help. And shouting HELP won't get you a
better answer or a quicker answer; please post a Subject with a
concise indication of what you're asking instead.
is there a built in function that changes a numberic field
to a text field
Click to expand...

CStr() or Format() will do so... but could you explain what you mean?
Do you want 1343 converted to "1343", or to "One thousand three
hundred and forty-three"? If the latter, you'll need to go to
http://www.mvps.org/access or to http://www.lebans.com and download
some custom code to do so.
 
Back
Top