Multiline

Dec 12, 2005

Hi, I want to save entries to an Access DataBase, but the entries are gonig to be like 3+ Paragraphs long (Including Carraige Returns). Can this be done, and is it recommended?

View Replies


ADVERTISEMENT

Problems Importing Multiline Data From Excel

Mar 31, 2006

when i import a spreadsheet into a table, there's one column that contains multiline data. for some reason, in the imported data, hard returns (alt-enter) are converted into squares, and the line breaks are in new places.

any idea how to avoid this? or how to go through programmatically and look for these squares? they're not a standard ascii character, so i don't know how to write a program to look for them and change them back into hard returns.

any ideas?

View 4 Replies View Related

Modules & VBA :: Linebreaks Not Working In Multiline String

Jul 10, 2014

I am trying to make pass through query that triggers a database restore on a SQL server based on a few parameters entered in a form.

As soon as i run the command button the output just put all lines as one line without line breaks.

Here is my code:

Private Sub cmdRestore_Click()
On Error GoTo ErrHandler
Dim sSQL As String
Dim sSQL_Local As String
Dim rs As ADODB.Recordset

[Code] ......

View 6 Replies View Related

Reports :: Splitting Single Field Into Multiple Text Boxes Or Multiline Text Box

Jun 4, 2013

I have a single field in a table called "Client Contact", where users enter a semicolon between the name, address, and city state & zip. My reason for this was so we could copy client info with a single copy and paste (like from an email). But, on the final report, it needs to have these three parts split up into different lines, or even different textboxes. I can't find a way to do that.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved