New Version 2.0 LimitTextInput.zip is a database containing a function to limit the input into a TextBox control. Will allow data input that will fit within the current displayable area of the control only. Handles both Keyboard and Mouse events. Includes a self contained function to mimic the Report objects TextHeight method.
Includes a Report to demonstrate the use of the core fTextHeight function to allow you to gain this functionality in the Format event of the Detail Section. This will allow you to respond to CanGrow events before they happen by moving/sizing your controls in the section's Format event. Example demonstrates how to vertically center the contents of a control within a fixed size box or section.
Removed early binding reference to CommandBar object
Correctly processes the following methods of generating a Paste operation
Missing Menu->Edit->Paste Special and Paste Append. Function appears to work properly without explicitly allowing for these Buttons.