I have set Text Formatting for my fields in a report, but the data seems to be coming up in the format it was entered in (14pt instead of 8pt). is there something i am missing?
Thank you for your post.
Return to Layout Mode (from the View menu) and click once on the field. Pull down the Format menu and select "Text...". Besides the Size being set to 8 Point, what Font is being used? It is possible a corrupt font is causing the problem. In addition, let me know if there are any styles checked other than "Plain".
whats strange is that for all of the fields on my report, they are New Time Roman @ 11 (which is the desired font/size)
but it still displays some data in the orig. font/size. i am copying from excel. i tried changing the size in excel, but it still seems to copy whatever formatting is there - odd.
can i have it format text upon input? i forsee my users copying from excel alot as they input old reports.
simply importing will not work, as they were using excels fields as layout fields, not as a proper spreadsheet.
is this something i should script? or should just run to cleanup?
i am hacking my way thru FM with this project. upon initial completion, i will take time to get a fuller grasp.
If you're doing a one time only cleanup, You can use this function in a Replace Field Contents with specify calculation option.
If you will be doing this repeatedly, script it.
Retrieving data ...