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: 67
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?
 

Setting multi-line text field to have both scroll bars and no line wrap, how?

Setting multi-line text field to have both scroll bars and no line wrap, how? Icon
Access 2007 on Windows XP

I am not seeing a property setting to enable a horizontal scroll bar for a text field.

And also I need to disable the control from doing line wrap.

Basically I want Access to display the text as-is and do no reformatting.

I have set my font to a mono-space font, so that point is successfully covered
 

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?
 

Multi-value Unbound Combo Box

Multi-value Unbound Combo Box Icon
I've read a few posts that state it is not possible to have an unbound multi-value combo box (Access 2007). Many of my bound forms have multi-value combo boxes, and I understand many programmers dislike them as they break some formatting standard rules (or so I've read). Anyway, I have no opposition to them since they work fine for the applications in which I've used them. Is it truth, myth, legend that they cannot be unbound? Is there a way to hardheadedly code this possibility into existence?

Let's see where this gets us
 

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.
 

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?
 

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.
 
Sponsored Links: