It's documented in the help under
Format Property that in order to prevent padding for Varchar fields, you have to set following properties of a textbox
.Format = "F"
.MaxLength = <Max # of characters>
>
>I am finding a strange inconsistency when saving a remote view where the fields in the data source (SQL Server 2005) are varchar.
>
>- When saving the remote view when the data is edited in the browse window, the varchars are *not* padded with trailing spaces. This is the behavior I want.
>
>- When saving the remote view when the data is edited in a base VFP form and base VFP edit box, the varchars end up being padded to their maximum width with whitespace. The edit controls do not have any input mask.
>
>I ensured that the view definition for the field(s) in question are actually varchar, not char. e.g.
>DBSetProp(ThisView+".x_desc","Field","DataType","V(20)")
--sb--