Hi guys,

Hope you can help. I have a alphanumeic text column where some of the
fields have a leading zero which i want to remove. I can't use the edit -
replace option to remove the zero because other characters of that field
might have a zero too. Is there a way programmatically or by a function to
remove the zero if it is 1st byte? Any help and /or examples would be greatly
appreciated.
--

Thanks in advance,
Matt
(access 2000)

make the field format a number format rather than text (number,double etc...)


"MaBell" wrote:

Hi guys,

Hope you can help. I have a alphanumeic text column where some of the
fields have a leading zero which i want to remove. I can't use the edit -
replace option to remove the zero because other characters of that field
might have a zero too. Is there a way programmatically or by a function to
remove the zero if it is 1st byte? Any help and /or examples would be greatly
appreciated.
--

Thanks in advance,
Matt
(access 2000)

That doesn't worked. That was one of the first things i tried. The
file/column field is already coming to me as a text field. It won't convert
to a nukmber cause the field is aplhanumeric. Anyone else???

"ben" wrote:

make the field format a number format rather than text (number,double etc...)


"MaBell" wrote:

Hi guys,

Hope you can help. I have a alphanumeic text column where some of the
fields have a leading zero which i want to remove. I can't use the edit -
replace option to remove the zero because other characters of that field
might have a zero too. Is there a way programmatically or by a function to
remove the zero if it is 1st byte? Any help and /or examples would be greatly
appreciated.
--

Thanks in advance,
Matt
(access 2000)

simple macro
check each field
if left(fieldvalue,1)="0" then fieldvalue =
right(fieldvalue,len(feildvalue)-1)


"MaBell" wrote:

That doesn't worked. That was one of the first things i tried. The
file/column field is already coming to me as a text field. It won't convert
to a nukmber cause the field is aplhanumeric. Anyone else???

"ben" wrote:

make the field format a number format rather than text (number,double etc...)


"MaBell" wrote:

Hi guys,

Hope you can help. I have a alphanumeic text column where some of the
fields have a leading zero which i want to remove. I can't use the edit -
replace option to remove the zero because other characters of that field
might have a zero too. Is there a way programmatically or by a function to
remove the zero if it is 1st byte? Any help and /or examples would be greatly
appreciated.
--

Thanks in advance,
Matt
(access 2000)