October 17, 200817 yr 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
October 17, 200817 yr 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.
October 17, 200817 yr 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.
October 17, 200817 yr 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.
October 17, 200817 yr Author 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
Create an account or sign in to comment