Hello All,
we are using AA User Defined Fields to track LC & LG amounts using Numeric fields, but according to limitation in default format we couldn't enter amounts which is over on million !!
so, I need to increase these fields' length to be 13 instead of 12 but when access Window Modification using GP Modifier I found no way to override current length and in format type I can just control digits before decimal.
Please help me with your suggestions.
Thanks.
*This post is locked for comments
Hi again,
Regarding mentioned case, we have built simple new form using VBA just to be used as alternative form when enter Numeric Fields value without number format restrictions that we have in the original GP form... this solution is working fine with us. Below you can find new form that will be displayed once numeric fields to be focused;
please share with me if you have better solution.
Regards,
Ehab
Hi Leslie,
I wonder, why we are getting like this limitation while related database table accept longer length & I already test to access related table & amend saved number to longer one then return to GP window & I note new number has been displayed correctly !!
Hi Ehab,
You cannot change the keyable length of the field. All decimal fields in GP are stored with 5 decimals. Therefore, the first 5 characters of your 12 character keyable length is used by the decimal digits. There is no getting around that. You have 7 digits to the left of the decimal making the maximum value for this field 9,999,999.99999. Simply put, you cannot change the field's length to 13 instead of 12.
Did you ask this question back in 2009? Seems like I just read an old post about this. Unfortunately, the answer hasn't changed.
Kind regards,
Leslie
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (