Display the value of an Option field

Dynamics 365 Business Central/NAV Developers Forum
1

Hi everyone,

How can I display the value of an Option field???

For example, the code Employee.PaymentMode returns 1, but I want it to display the corresponding OptionString…

How to do that???

2

Did you set OptionCaption for the field in table?

3

Hi Poppins,

It depends on which context you want it to return the value in. Is it to a report or form/page? Or?

Sometimes if you work with the option field values in code then it behaves differently from when you just display the field “normally” in a report or form.

4

Infact, I need to display it in an Excel file (I am exporting data to Excel)…

5

Hi,

Have you tried using the FORMAT function?

FORMAT*(record**.option_field*);

Best regards.

6

Thanks a lot [:)]