General information
Category:
Forms & Form designer
Title:
Grid control and dynamic lookup
I need help to display a looked-up string in a grid, whose RecordSourceType = 1 (alias). This string is generated from the value in an eight-character field in the grid’s RecordSource. (NOT the field’s actual value).
I specifically need this column’s ActiveControl to be
1) READONLY.
2) ENABLED. (The control’s DBLCLICK event must be available at runtime.)
I’d like a textbox for the column’s ActiveControl. If possible I’d also like to use a simple ASCAN() lookup expression.
I have, so far, been unable to create a useful “dynamic lookup” expression for the property sheet’s ControlSource. In my best attempt, when clicked, the displayed value is suddenly truncated to the ControlSource’s length (eight characters).
Is this directly and simply doable? If not what approach should I use?
Thank you VERY much for any suggestions!
Spencer
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only