Converting a numeric field to text

[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?

 

[Gina Whipp]

Gingerbread,

Without changing the field type in the table you can it display the way you
want by using Format([rc],"00000")

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm