Announcements
I want to store item and customer specific notes in user-defined fields so that they can print on work orders.
I have been told that I can not print the contents of notes, and the user-defined fields are too small. Is it possible to change the field definition to allow more characters?
I could do it directly in SQL but no telling what it would break.
If your main objective is to print some text on report then you can have new table with fields and with the help of custom code can save and print those on report.
Hi there
No, it is not possible to change existing GP table structures in any way.
I would look at adding a custom field of the datatype you need as a customization. You could use Modifier.
As VBA is "End of Life" I would recommend moving away from VBA to other tools, such as VSTools or Dexterity.
However, the easiest and simplest solution is GP Power Tools, which requires no external tools or development environments. No separate deployment or upgrade processes either.
Beginner’s Guide to Adding Custom Fields
Replacing VBA with GP Power Tools
Moving on from VBA Mindset
Kind regards
David
While you could use Dexterity or VSTools
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156