Problem with Memo Fields

[harleyskater]

I am not sure if this is only an access 2007 problem, or if its maybe a problem on the server side of this, I have a sql back-end on the server. If I enter data into a memo field access 2007 does this weird thing where it drops the last word to a new line. ie.

---Entry 1:
Hi my name is Harley
---Entry 2:
Hi my name
is Harley

---Result 1:
Hi my name is
Harley
---Result 2:
Hi my name
is
Harley

Anyone know how to unconfigure this ! ; ) : )!

Thank you in Advance : )

 

[harleyskater]

Or if there was a different field type that would still allow you to enter different lines of data within the same field?

I am not sure if this is only an access 2007 problem, or if its maybe a problem on the server side of this, I have a sql back-end on the server. If I enter data into a memo field access 2007 does this weird thing where it drops the last word to a new line. ie.

---Entry 1:
Hi my name is Harley
---Entry 2:
Hi my name
is Harley

---Result 1:
Hi my name is
Harley
---Result 2:
Hi my name
is
Harley

Anyone know how to unconfigure this ! ; ) : )!

Thank you in Advance : )

 

[harleyskater]

Does anyone else have this happen to them, or, is this just a problem local to me? HELP :X