I tried searching the forums for help with my MID function problem, but it's too short of a search term to get any results. I have field CntlNum, which is a 17 character alphanumeric field. I need to populate field AccntNum with the first 10 digits of CntlNum.
In the AccntNum field on my form, I set the default value to =MID(CntlNum, 1, 10), but it's not working. Suggestions?