Finance | Project Operations, Human Resources, ...

Is it possible to change the TYPE of a user-defined field?

(0) Share

Report

Posted on by boculjan

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.

All responses (2)

Answers (0)

Almas Mahfooz 11,003 User Group Leader on at

Like (0)

Report

RE: Is it possible to change the TYPE of a user-defined field?

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.
Suggested answer

David Musgrave MVP ... 13,932 Most Valuable Professional on at

Like (0)

Report

RE: Is it possible to change the TYPE of a user-defined field?

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

winthropdc.wordpress.com/.../

Replacing VBA with GP Power Tools

winthropdc.wordpress.com/.../

Moving on from VBA Mindset

winthropdc.wordpress.com/.../

Kind regards

David

While you could use Dexterity or VSTools