Database development and training for Birmingham and the midlands
Specialists in Microsoft Access and Visual Foxpro database training and development
I am happy to hear from existing clients but I am taking no new calls.
Visual Basic and Visual FoxPro functions to remove spaces
VBATrim(), LTrim(), RTrim()
VFPTrim(), LTrim(), RTrim(), AllTrim()
Common Syntax Notes
The syntax of the languages appears to be very similar but there is a difference in the behaviour of the Trim() function. In VBA Trim() removes leading and trailing spaces; in Visual FoxPro Trim() removes trailing spaces only and performs the same function as RTrim(). Use AllTrim() in VFP to remove leading and trailing spaces.