Field Formatting
-
- Posts: 29
- Joined: Tue Oct 10, 2017 12:44 pm
Field Formatting
I have a numeric field from a .dbf in the record band of a report but it will not print zeroes. The properties indicate "Show Zero". I^ve tried different fonts, field sizes, etc. If the field has a value other than 0 it prints fine. What could I be doing wrong? I have the same problem with 6.5 xbase, 8.1, and 10.0____Thanks,__Randal Ferguson__
=> RE: Field Formatting
It could be that the field is null rather than zero.__One way around this would be a calculation with expression:__IIF(fieldname=0,0,fieldname)__This will allow nulls to display as zeros.____Kathleen__R&R Support__