Too many characters ?

[gloerick]

Hello All,

In creating a new layer I have a number field for account numbers, However when the number exceeds 7 characters and if you click out of the field it will open spaces in the field no longer showing all numbers until you reclick in the field

and all numbers look normal.

This would not be such a big deal but I need to print these numbers and not spaces in the field.

Why would clicking out of the field make it show spaces in the number and not the entire number until reclicked into ?

Any help please.

Thx much

Erick

[Vaughan]

Check the field formatting, both the text (font, size, style) and the paragraph (alignment, spacing, indents etc).

Lastly, make sure the field is wide enough to display the data that's been entered: if it's too small FMP will display #####s to indicate that not all of the number is visible.

[comment]

Can you post a simple file showing the problem? I suspect you may be seeing a shift to scientific notation - but that wouldn't occur with only 8 digits, and it wouldn't have spaces in it.

FMP will display #####s to indicate that not all of the number is visible.

I believe it will display a single question mark.

[Vaughan]

Oh yeah, it's Excel displays ####s.

Either way, that's probably the problem.

You can also set the fields Number Format to "leave data formatted as entered" to stop it from changing into scientific notation.

[gloerick]

Great thank you,

It was in the number formating options

"set to leave data formated as entered"

fixed right up

THank you much for the fast response

and resolution, most appriciated.

Thx

Erick