• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

Multi Line Text Box


I'm trying to generate a table dump in MS Access, and I'm just wondering how can I have a multi-line text box in Access?

Thank you.
APD Toronto
APD Toronto
3 Solutions
Dale FyeCommented:
size the textbox for however many lines you want it to be.

Then, select the textbox and view the properties dialog.  On the "Other" tab, there is a property "Enter Key Behavior"; change that value to "New Line In Field".

If the value in that textbox is going to be <=255 characters, you can define it as "TEXT", but if it could be >255, then you should define the data type of the field as MEMO.
APD TorontoAuthor Commented:
Can you define the textbox as memo even if it is not bound?
APD TorontoAuthor Commented:
I keep getting:

The setting for this property is too long.
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

APD TorontoAuthor Commented:
Or, can you remind me how to write to a .txt file
Gustav BrockCIOCommented:
> .. how to write to a .txt file

That's quite easy using the sample code here:


Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can use TransferText to write to your text file:

DoCmd.TransferText acExportDelim, , "YourTable", "YourFile"

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now