Converting a numeric field to text

  • Thread starter Thread starter Gingerbread
  • Start date Start date
G

Gingerbread

I want to convert a numeric field to text in the same way that you can in
excel. I have a field that can contain either a 2 or 3 digit numeric value
and i want to convert it to a text value with trailing zeros. In excel i
would use the following function [Text,rc,"00000"]. is there anything
similar in access?
 
Back
Top