Mulit Line Text Box Auto Populate Fileds

[pagi33]

HI,

I am creating a search form where in customer name will be 3 controls 1 is search box second search button below that will be list of customer name.

Now i have trying to replicate contactsweb template from access website where in NameList form has created same thing what i want i created same form but my auto populate text box third control is not showing multiline.

Below is the link for template

http://office.microsoft.com/en-in/te...101114814.aspx


I need help for having multli line in text box.



Thanks

Pagi

[rpeare]

if you want a carriage return in your text box you have to populate it with the string vbcrlf so for instance if you wanted their name, address then phone number in the text box you'd do something like

=[PersonName] & vbcrlf & [PersonAddress] & vbcrlf & [PersonPhone]

as the control source of the text box. I'm not downloading the application so I'm guessing here but if the text box is an actual data field that people use for data entry you can move to the next row of a text box using CTRL-ENTER to force a hard return rather than a soft return when they reach the end of a row.

[June7]

If you want multi-line during data entry, textbox has a property Enter Key Behavior. Set it to 'New Line in Field' and pressing Enter key will force a new line and focus will remain on the textbox instead of moving to next control, unless this feature is not available in web db, otherwise try the CTRL-ENTER rpeare suggested.

If you want to combine 3 fields for display in a single textbox, then use concatenation as rpeare shows.