Sep 3, 2009

Finding out field size in front end

When some one asks you whether you can find out the field size in Apps front end, tell them yes and also show them that it's done this way:

  1. Navigate to the form on which you want to find the field size.
  2. Navigate to the field for which the size needs to be determined.
  3. Click on Help > Diagnostics> Properties> Item (It might ask for database password, so you should have it handy).
  4. Select Max Length in the Property Drop down box.
  5. You will get the value in the Value field. This is your field size for the field selected in step2.