SQL Text data type for form Memo Field

  • Thread starter Thread starter Tman
  • Start date Start date
T

Tman

Hello,

I have an Access front-end to a SQL database.

I have a description field within one of my tables. I would like the end
users to be able to type into this field, hit enter and go to another
line within the field. The only way I can accomplish this (that I know
of) is to make the SQL field data type, 'Text'. I think I remember
reading that there is a lot of overhead (resources, memory allocation)
using a text data field.

Could someone strighten me out on this one. Can I use a SQL text data
type like this, without putting on load on resources?

Thank you for your time!

Tman
 
Let's see…. a couple months thinking that it couldn't be done a certain
way..I then finally send out a message to this group..then After sending
the message I immediately go into my ADP and figure it out.

Within properties of the field I went to 'Enter Key Behavior' and
selected 'New Line in Field'.

Never mind:)
 
Back
Top