web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Form Input : Convert s...

Microsoft Dynamics AX (Archived)

Form Input : Convert small letters to Capital letters

(0) Share

Report

Report

Posted on by yasu

In My form the User will input the value of Mac Address

My Requirement : In case the user inputs any smaller letters like aabb etc I want these to be

converted into Capital Letter like AABB??

Please help me !!

aa77bb66 　→　AA77BB66

ccdd5566　→ CCDD5566

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report

Use strUpr()

msdn.microsoft.com/.../aa880106.aspx

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,807 Most Valuable Professional on at

Like (1)

Report

I didn't remember the exact function, so I simply put ax string uppercase into my favorite search engine and got it as the very first link. You may want to do it by yourself next time, because it's clearly much less work than creating a new forum thread.

The answer is strUpr().

Was this reply helpful? Yes No
yasu on at

Like (0)

Report

thank but can you tell how to use?? like where to add it and how to add it??

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

Like (0)

Report
You put a string there and it returns another string with all letters converted to uppercase, which you can take and assign somewhere. Like this:

str upper = strUpr('aa77bb66');

You mentioned you want to do it with a field, so just put the field to both sides:

myTable.MyField = strUpr(myTable.MyField);

Where you should call the code depends on when you want to execute the logic. For example, you may want to do it immediately when a user changes the field, or when you're saving changes to database.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans