Sage 100

What is the secret to getting a magnifying glass to display for a look up when using a UDF linked to a UDT? Sometimes it does, sometimes it doesn't. I haven't pinned down the variables. See attached for what I DON'T want to display. UDF is set a a multiline being validated against a UDT. TIA

Check the height. I think you want to keep it at 1.

Jeff, set the UDF as a multi-Line

The row height trick did it. I thought that was it but apparently you have to hit the mark when you draw the field. When I set it to one, the MG didn't appear. So I reset the panel and started over drawing the field to a height of one the first time.

Kim, the UDF has to be set to multi-line in order to validate a table. You get an error message otherwise. Thanks to both of you. Remember it is Saturday. Don't stay too late............

Jeff, for the row height can't you adjust it after drawing it? I routinely adjust the size of boxes because I never draw them precisely.

Gene, that is usually my SOP also. But if I manually size it (via the properties tab) to 1.0 height, the magnifying glass doesn't seem to appear. So I delete the box and draw it precisely to 1.0 and the magnifying glass appears. Go figure. Still not sure if it is me or Sage yet.

You need to add the UDT validation for the UDF 'prior' to adding it to a screen. Adding the UDT 'after' the field has already been placed requires you to delete it and place it again. And regardless of the size you drag the field when placed, it will warn you that it must be set to 1 and sets it for you.

Interesting. Thanks. My normal SOP on this is to create the UDT first, then the UDF with it being validated against the UDT, then add it to the panel. So there must be one minute step that I missed the first time around.