Finance | Project Operations, Human Resources, ...

How to add thousands separated (,) format in Textbox with int data type

(1) Share

Report

Posted on by nbhatti2001

222

Hi,

I have int field data type in table as I don't need dcimal points value, I have to show on a form header. It is working fine. I need to formate (,) as thousands separater.

Please suggest which extended data type I can use or there some other solution for it.

I know I can do this by change the type to Real and use extended data type "AmountMST", but I don't want to change the data type.

Thanks.

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Ariba Mehdi 166 on at

Like (0)

Report
Copy link

Link copied!

Hi there,

I think you mean to use 1000 separator on the form field value like, 2000 -> 2,000.

Navigate to the field control on the form and change the property ThousandSeparator = Comma.

Hope it helps!

Was this reply helpful? Yes No
Martin Dráb 239,634 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

An integer is a number, such as 5 or 999. It's a single value, not a list of values that need to be delimited. Therefore I have no idea why you're saying that you need to formate it comma separated. Please give us more information about your requirements.

Was this reply helpful? Yes No
nbhatti2001 222 on at

Like (0)

Report
Copy link

Link copied!

Thanks Ariba,

For the corection, I need thousands separator. I try to find it in field property on form but failed. Here is the property list screen shot from my VM. I have sort the properties alphabatically. I have trid with the table field property as well. I am using D365FO VM.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,634 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Moved from Dynamics AX forum.

Are you sure that you want to format this single integer field in a different way than all other integers in the system?

If you mean that you want to format it as a real number, but without decimal numbers, you can - use a real edit control and set No Of Decimals properties. Usually you shouldn't hard-code details of the format (such as ThousandSeparator); it should come from each user's regional settings. By the way, ThousandSeparator is a property of real controls, not integer controls.

If you want to store the number as int in database and display is as a real, you can use a display (or edit) method.

Was this reply helpful? Yes No
Ariba Mehdi 166 on at

Like (1)

Report
Copy link

Link copied!

Override the field control method formatStr and use the format: #,0;(#,0) to get 1000 separator.

Try this:

Was this reply helpful? Yes No