InfoQube IM - Community

Submitted by WayneK on 2018/11/15 17:30

For number fields, how to do I set:

- comma separator

- number of decimal places shown

Wayne

Comments

Hi Wayne,

It seems that the field property number format is currently broken. I'll fix it. You're left with the general Windows settings (control panel or settings app)

Pierre_Admin

IQ Designer

Thanks Wayne and Pierre for finding that

Just this week I had been trying to format a numeric field using the the field property box with no success.

However I did find that using the 'Options' settings I was able to achieve the formatting with the

method.

I imagine the comma separator can be fined in a similar manner.

John

I see that number formatting has been fixed in 111a but still can't figure out how to set decimal places and commas

Field properties only shows "Standard" and "Currency" as formatting options. The standard option displays two decimal places. I want none for this particular field. Also couldn't find anything in the Column menu or Manage Fields.

I didn't understand John's suggestion for setting it using options. In any case, that wouldn't help since I want to set it by field, not universally or by file.

Wayne

Hi Wayne,

Enter 0 in the format should do it

For the full reference of available formats, refer to this:

https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/format-function-visual-basic-for-applications

HTH !

Pierre_Admin

IQ Designer

Wayne,

I was referring to the field options box at the bottom of the Field properties window, not the file options although I (now) see that could be ambiguous! In any event, as Pierre says, you can enter the formatting code directly now that the format box has been fixed.

John