>how can i use the alltrim while saving data.
>
>I am using the control sourse property for all the fields to save the data for example
>control source = sub.sub_title
>
>so now when i save a information to the table's field it is being saved "abc "
>
>so it is also saving the empty spaces on the right side of data to the table.
>
>the problem is when i put my cursor onto that field the cursor is appearing after those spaces and again i need to do a back space.
>
>Is there a way i can use the all trim also thru the properties window.
>
>
>Thank you.
FoxPro fields are a fixed width, so even if you ALLTRIM() the value, you'll still be saving the spaces at the end.