Field length num 10 digits

[Acda]

Hi there,

I have a numeric field in my dbase, that contains hexadecimal numbers. I have to insert new numbers but they have to be 10 digits long. If not I have to get a warning.

I cant use the option- range because it's hexadecimal.

I've tried Length(NumtoText(Field)) = 10 but that didn't work either.

(Because when your field is text, you can set the length)

I hope there's some one who cann help me,

Thx in advance, greetz.

[CobaltSky]

Hexadecimal numbers incorporate letters up to F as well as the numerals 0 to 9 - and therefore they are an alphanumeric data type, and are required to be stored in a field type text rather than a number field.

If you change the field type to text and then use the validation formula Length(YourField) = 10 you will have more success.

[Acda]

Thx for the answer Ray, problem however is that the data is coming from an antenna. The antenna scans a chip and puts the data from the chip in the field.

When I set the field to text, he also puts an enter in the field. And when I export the data, I get a little square (the enter) behind the 10 digits.

Maybe I should find a way to delete the enter ?

Is it possible to delete it automatticaly ?

Thx in advance, greetz.

[CobaltSky]

Try Substitute(AntennaScanData, "