Convert Numbers to Text

  • Thread starter Thread starter Ko Zaw
  • Start date Start date
K

Ko Zaw

Refering Num2Text Function in
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_actips.asp
It done well by using a calling subroutine in a form, page, or module
in your database application. But I like to use in update sql. like

docmd.runsql "UPDATE MyTbl SET MyTbl.MyNumText =
Num2Text([MyTbl]![MyNum],"ConvTypeRoman","CapUpperCase");"

Problem is Query don't understand this function Num2Text, and error
occur in update process.
Did I make someting wrong in coding.
 
I got it.
Simple as
Docmd.runsql "UPDATE MyTbl SET MyTbl.MyNumText =
Num2Text(MyTbl]![MyNum],3,3);"

If you avoid null value in MyNum, use
Docmd.runsql "UPDATE MyTbl SET MyTbl.MyNumText =
Num2Text(Nz([MyTbl]![MyNum],0),3,3);"

If you avoid null value in MyNum and also MyNumText is text field of
255 size.
Docmd.runsql "UPDATE MyTbl SET MyTbl.MyNumText =
Left(Num2Text(Nz([MyTbl]![MyNum],0),3,3),255);"

Then I add only as last word.
Docmd.runsql "UPDATE MyTbl SET MyTbl.MyNumText =
Left(Num2Text(Nz([MyTbl]![MyNum],0),3,3),251) & "" only"";"

Thank you for interesting...
Ko Zaw
 
I got it.
Simple as
Docmd.runsql "UPDATE MyTbl SET MyTbl.MyNumText =
Num2Text(MyTbl]![MyNum],3,3);"

If you avoid null value in MyNum, use
Docmd.runsql "UPDATE MyTbl SET MyTbl.MyNumText =
Num2Text(Nz([MyTbl]![MyNum],0),3,3);"

If you avoid null value in MyNum and also MyNumText is text field of
255 size.
Docmd.runsql "UPDATE MyTbl SET MyTbl.MyNumText =
Left(Num2Text(Nz([MyTbl]![MyNum],0),3,3),255);"

Then I add only as last word.
Docmd.runsql "UPDATE MyTbl SET MyTbl.MyNumText =
Left(Num2Text(Nz([MyTbl]![MyNum],0),3,3),251) & "" only"";"

Thank you for interesting...
Ko Zaw
 
Back
Top