# Option Data Type

**URL:** <https://www.dynamicsuser.net/t/option-data-type/9328>\
**Category:** Developers Forum\
**Created:** [November 4, 2004, 8:17am UTC](https://www.dynamicsuser.net/t/option-data-type/9328 "2004-11-04T08:17:07Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![soumyadip](https://avatars.discourse-cdn.com/v4/letter/s/9fc29f/32.png) [@soumyadip](https://www.dynamicsuser.net/u/soumyadip)\
**Post date:** [November 4, 2004, 8:17am UTC](https://www.dynamicsuser.net/t/option-data-type/9328/1 "2004-11-04T08:17:07Z")

</div>

I have a field in a table called Height, datatype is option. Values are High,Medium,Low. In report when i am printing that field it is showing 0 for high, 1 for medium & so on. Means it is showing respective integer position. How can i deal with this problem? Thank You.

---

<div class="post-metadata">

**Author:** ![Nelson](https://avatars.discourse-cdn.com/v4/letter/n/dec6dc/32.png) [@Nelson](https://www.dynamicsuser.net/u/Nelson)\
**Post date:** [November 4, 2004, 8:29am UTC](https://www.dynamicsuser.net/t/option-data-type/9328/2 "2004-11-04T08:29:33Z")

</div>

Check the OptionCaption and the OptionCaptionML properties of both the field on the table and the textbox on the report.

---

<div class="post-metadata">

**Author:** ![stryk](https://avatars.discourse-cdn.com/v4/letter/s/ee59a6/32.png) [@stryk](https://www.dynamicsuser.net/u/stryk)\
**Post date:** [November 4, 2004, 8:53am UTC](https://www.dynamicsuser.net/t/option-data-type/9328/3 "2004-11-04T08:53:51Z")

</div>

```auto
FORMAT(Option,0,'<Text>');
```

---

<div class="post-metadata">

**Author:** ![stryk](https://avatars.discourse-cdn.com/v4/letter/s/ee59a6/32.png) [@stryk](https://www.dynamicsuser.net/u/stryk)\
**Post date:** [November 4, 2004, 8:56am UTC](https://www.dynamicsuser.net/t/option-data-type/9328/4 "2004-11-04T08:56:56Z")

</div>

By the way, soumyadip:

> **quote:**
> 
> | General comments and suggestions to the Microsoft Business Solutions User Group. Debates that are not website - but user group specific. |
> | --- |

This is the description of this forum. You are posting in the wrong forum, better would be NAVISION DEVELOPMENT.

---

<div class="post-metadata">

**Author:** ![soumyadip](https://avatars.discourse-cdn.com/v4/letter/s/9fc29f/32.png) [@soumyadip](https://www.dynamicsuser.net/u/soumyadip)\
**Post date:** [November 8, 2004, 6:09am UTC](https://www.dynamicsuser.net/t/option-data-type/9328/5 "2004-11-08T06:09:55Z")

</div>

[B)] where should i post? Please tell me the full name of the group.

---

<div class="post-metadata">

**Author:** ![Nelson](https://avatars.discourse-cdn.com/v4/letter/n/dec6dc/32.png) [@Nelson](https://www.dynamicsuser.net/u/Nelson)\
**Post date:** [November 8, 2004, 8:39am UTC](https://www.dynamicsuser.net/t/option-data-type/9328/6 "2004-11-08T08:39:10Z")

</div>

Group: **Navision (aka Financials / Attain)** Forum: **Navision (Attain/Financials) - Developer Forum** Description:

> **quote:**
> 
> | Questions and discussion about development and modifications in Microsoft Business Solutions Navision Edition (formerly Navision Attain and Navision Financials). |
> | --- |

Link: [http://www.mbsonline.org/forum/forum.asp?FORUM\_ID=9](http://www.mbsonline.org/forum/forum.asp?FORUM_ID=9)

---

<div class="post-metadata">

**Author:** ![frodew](https://avatars.discourse-cdn.com/v4/letter/f/e79b87/32.png) [@frodew](https://www.dynamicsuser.net/u/frodew)\
**Post date:** [November 9, 2004, 12:54pm UTC](https://www.dynamicsuser.net/t/option-data-type/9328/7 "2004-11-09T12:54:14Z")

</div>

> **quote:**
> 
> | I have a field in a table called Height, datatype is option. Values are High,Medium,Low. In report when i am printing that field it is showing 0 for high, 1 for medium & so on. Means it is showing respective integer position. How can i deal with this problem? Thank You. You can use the OptionCaption property to define what to display.  
> _Originally posted by soumyadip - 2004 Nov 04 : 08:17:07_  
> |
> | --- |

---

<div class="post-metadata">

**Author:** ![admin1](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/admin1/32/7476_2.png) [@admin1](https://www.dynamicsuser.net/u/admin1)\
**Post date:** [November 9, 2004, 1:45pm UTC](https://www.dynamicsuser.net/t/option-data-type/9328/8 "2004-11-09T13:45:23Z")

</div>

Moved by admin