Text box length, and persistence

[sdpsc]

I am using RDO to connect to a FoxPro DBF database in VB6. When I display the contents of a field in a text box, and then try to edit that text box, it won't let me type in any more characters than that record had in it initially. For example, if in the last name field is the last name "Cooper", it will not let me type in anything with more than 6 characters. The max length on the text box is 25. Does anyone know why this happens and how to make it not happen?

Also, how do I change an RDO recordset's state to persistent?

Any help would be greatly appreciated! Thanks!

 

[AndyLee100]

I don't know much about RDO but is the text box a bound control? Is this causing a problem?

Andy

 

[Error7]

Or it could be the contents of the field are padded with spaces.

Try hitting the "end" key and see where the cursor is positioned.

[gray]Experience is something you don't get until just after you need it.[/gray]

 

[sdpsc]

Thanks to both of you for your responses, it was the paddes spaces though bigalbigal, thanks!

 

[BobRodes]

I don't know FoxPro at all well either, but in SQL server, if you use varchar you won't have padded spaces, and if you use char you will. Perhaps there's an analogy in Foxpro, with respect to field types?

Bob