Topics Search

Multi-line text box - can't get it to work in Access 2003

Multi-line text box - can't get it to work in Access 2003
Views: 70
I'm using Access 2003. I'm trying to set up a multi-line text box on a form where the user must have control over where the line breaks occur. I've set the "Enter key behavior" parameter to "New Line in Field".

However, after keying the first line and pressing the Enter key, Access is treating it as a completion of the entry and tabbing to the next control.

I've also tried using Shift + Enter and Ctrl + Enter, but with the same result.
Sponsored Links:

Similar posts...

 

Coloured text within the same text box

Coloured text within the same text box Icon
Has anyone ever used VBA to enter text into a text box with sections of the text in different colours and return to the next line? for example.

On the enter date we went to look at a problem. When we arrived it was enter time. The problem was related to enter part description. I'm currently using access 2003.
 

Link Multi Text boxes

Link Multi Text boxes Icon
How do I link multi text boxes. I have 1 text box with a height of say 720, on text box #2 I type in a size say 120 in another text box will say whats left e.g 600. then when I click to the next box #3 and enter say 200 the box that said 600 changes to 400. and so on.
 

Hide report object if no value

Hide report object if no value Icon
In Access 2003/XP/2000/97, I've created a report. In my report, I want to hide a text box if it has no value. Currently, if the text box value is nothing, a blank line is printed in the report. Is there a way to not print blank lines if my text box has no value?
 

Change the background color of a text box based on whether a value has been entered in Access 2003

Change the background color of a text box based on whether a value has been entered in Access 2003 Icon
Question: In Access 2003/XP/2000/97, how can I apply a conditional format on a text box? I want to change the background color to red from white when the text box has not been filled in (null value). How do I do this?
 

Values from list box into text box

Values from list box into text box Icon
I currently have a multi select list box named 'raisedby' on a form called 'create graph'. I am trying to get all the values that are selected in multi list box onto a report at on click event of my form.

What is the best way to do this? Could I put all the value into a text box on the report?
 

New line in memo box

New line in memo box Icon
I have a text box in a form that I want to feed into a memo box on the same form I am having trouble getting this to work in VBA. I imagine that the user would type their sentence or not in the text box and then click a button and it would appear in the memo with a time tamp and the sentence. if they did a new sentence and clicked again it would add to the memo on a new line and keep any old info.
 

Run time 2465 Error with Multi select text box

Run time 2465 Error with Multi select text box Icon
I found an article and code sample I am trying to run: [LINK] . I am running access 2003 sp3 on windows 7.

Following the example provided I get an error when opening the form: Run time error 2465 - "Access can't find the field myselections referred to in your expression" . I have a text box per the example named mySelections on my form.

I have searched on found remedies ranging from reinstalling sp3, turning off name auto correct, and of course confirming the text box is named properly. I continue to get the error. Is thisa common error and are there any other suggestions for troubleshooting this?
 

Best Practices When Using Microsoft Office Access 2003 in a Multi-user Environment

Best Practices When Using Microsoft Office Access 2003 in a Multi-user Environment Icon
Learn techniques you can use to improve the performance and efficiency of working with your multi-user Access applications.
This article looks at ways you can improve the way you work in a multi-user environment with Access applications. By utilizing some of these techniques, you can reduce the chance for errors and improve the performance of you databases.
 

Conditional formatting in Access 2003/XP/2000/97

Conditional formatting in Access 2003/XP/2000/97 Icon
Question: In Access 2003/XP/2000/97, how can I apply a conditional format on a text box? I want to change the background color to blue when the text box has focus. How do I do this?
 

Multiple Line Input Box

Multiple Line Input Box Icon
I have been searching online for this to no avail. I am trying to make an inputbox that can show more than one line of text. I have set up a button that when clicked, will send an e-mail to the e-mail address associated with the record.

2 input boxes show up. One for the subject line and one for the message itself. you can only see a limited amount of text and I would like it to show maybe 5 or 6 lines as the message will almost definitely span longer than the text field provided.

I don't want more than one text box on the input box to enter the message, just a larger one to view the whole message at once.