Microsoft Dynamics NAV (Archived)

A Decimal value 88.5 in the list as right-aligned text 88:30

(0) Share

Report

Posted on by Community Member

Hi,

I want to have in the list a decimal value of 88.5 as right aligned text (Example: 88:30).

I tried to solve this problem with c# code, but it's works only with Text-box or label and in the list is hidden :(

In other words, for me it's important that a list-field whose data type is Text was aligned to the right.

How can I solve this problem?

Thanks

Cezary

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Suresh Kulla 50,269 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Are you referring to the page or report ? if on page try Format Function on report you can use convert function to convert into text and format.

Was this reply helpful? Yes No
Rabin 2,976 on at

Like (0)

Report
Copy link

Link copied!

Hey,

Use "ROUND" function with Precision "0.001"

==>ROUND(1234.56789, 0.001, >) returns 1,234.568

Ref: msdn.microsoft.com/.../dd301418.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

on the page, but after converting the text (each text) is aligned to the left.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank's but for me it's important that a list-field whose data type is Text was aligned to the right.

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (0)

Report
Copy link

Link copied!

it seems that control-addins are disabled within repeaters. so it won't work anyway.

follow forum.mibuso.com/.../trying-to-do-a-control-add-in-in-a-list-page

it only works in page types like card.

as a workaround you could work with PADSTR: format the value as you like, fill the value at the beginning with as much spaces you need according the text length of the field.

for that follow forum.mibuso.com/.../format-text-with-leading-zeros

Was this reply helpful? Yes No
Verified answer

Ashwini Tripathi 4,624 on at

Like (0)

Report
Copy link

Link copied!

You can use Decimal property on Table & Page or you can use Round function on trigger OnAfterGetRecord.

If your source field is Text use Format function.

It will be better to stick to Nav Standards.

Although it is possible to right allign the decimal or integer values of text field by converting the value to Variant, but other limitation and issues creaps in, to handle it again you will require to do some customizations.

One way more you can write a function and fix the max no of characters that can be displayed in the field. Get the length of the value and add no of spaces in front similar to PADSTR which does same thing at the end of the string basically reverse functionality. And call the function in OnAfterGetRecord.

Or you can add the decimal variable on the page and assign the value from this field to decimal field in OnAfterGetRecord trigger. You need to Round the Value with proper precession. Provided you are not going to perform filtering, although will work but processing will be slow.

Was this reply helpful? Yes No