Multiline
Dec 12, 2005Hi, 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 RepliesHi, 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 Replieswhen 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?
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] ......
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