Microsoft Dynamics AX (Archived)

Form Input : Convert small letters to Capital letters

(0) Share

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 (4)

Answers (0)

Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report

RE: Form Input : Convert small letters to Capital letters

Use strUpr()

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

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 236,394 Most Valuable Professional on at

Like (1)

Report

RE: Form Input : Convert small letters to Capital letters

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

RE: Form Input : Convert small letters to Capital letters

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 236,394 Most Valuable Professional on at

Like (0)

Report
RE: Form Input : Convert small letters to Capital letters

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