Quote Originally Posted by lucas
I haven't worked in Access for a while and when I did it was as a beginner but I remember being able to use a textbox that would hold more than 256 charactors. I could be wrong, may have had to use a memo box. Could anyone give me some insight.
You will need to make sure that your data type for your field (set via the table design) is = memo

From the Access Help File (Access XP/2002)
"Up to 65,535 characters. (If the Memo field is manipulated through DAO and only text and numbers [not binary data] will be stored in it, then the size of the Memo field is limited by the size of the database.)"

In the form, set Scroll Bars property set to "Vertical" for your textbox for that memo field (Under the Format tab).

In Access XP/2002 at least, there is a property under the Other tab - Enter key behavior that you can set to "New Line in Field". I can't remember if Access 2000 or 97 has that. I don't have that at home and I don't use a memo field often.
Quote Originally Posted by lucas
Also seems like you could compile mdb into stand alone. Not mde but true stand alone but you needed an addon for access. Been too long I guess.
You cant really compile an Access database into a .exe or stand alone. What you can do (if you have the developer edition of Access) is is to distribute a runtime version of Access that allows the user to open and use Access files but not create anything.

Creating an .mde file compiles that code (someone may have to correct me on that one) and locks all the objects in the database (i.e. no changes can be made). Additionally this protects any code you have incoporated from prying eyes as it cannot be viewed.

I think it is typically more often done with a split db situation;
Front End (*.mde) - Contains forms, queries, reports, modules.
Back End (*.mdb) - Contains tables.
(Be sure that you have a copy before creating an mde in case you do need to make any changes or add objects.)

That is a bit of a simplistic overview but it should serve as a starting point for you, I hope.

Not sure if that answers your question or not. If not, post back and we'll try and get it sorted out.