text wrapping memo?

[madEG]

Wow. I am stumped. I can't for the life of me see why this is happening...

I am using a 2003 mdb against a SQL Server db. The table on the sql server side is char(1000), so when I link the table to the mdb it sees it as memo. Ok, no problem... (All SQL Server driver for ODBC defaults)

But when I type in text into the memo control the text wraps as shown in the screen shot after I hit the space bar. It is almost like the char(20) is being replaced with w 13/10. Crazy! But just for that memo control...

e.g. I type: "Item" and as soon as I hit the space bar before the "1" the cursor jumps down to the next line...

What on earth is going on? Thoughts?

Thanks,
-Matt G.

 

[madEG]

Rats. I just took the same form and tried it against an access table and not the sql server linked table, and the problem went away...

Double rats.

I guess it is a driver issue. I do some testing and report back when I make some headway...

 

[madEG]

Ok, I noticed that the sql server backend tables' text fields that were misbehaving were char instead of varchar - which was an error on my part when I typed up the DDL.

I mod'd the tables to be varchar and the odd behavior stopped. So, while it is no longer a problem, it does remain a mystery.

Moving along...