What is vbCrLf???

syedshaffee

Hey people,

Can some give me a simple explanation on

Expand|Select|Wrap|Line Numbers

vbCrLf

I Don't exactly known what it is used for

Sep 18 '12 #1

Subscribe Reply

✓ answered by TheSmileyCoder

It stands for
vb: Visual Basic
Cr: Carriage Return
Lf: LineFeed

In the ole days of typewriters the carriage return means to move the carriage all the way back left.
Linefeed simply is to push the paper in the typewriter up a line, giving a new blank line.

For a bit more Detail:

Expand|Select|Wrap|Line Numbers

vbCrLf = vbNewLine = chr(13) & chr(10)

On a interesting note you will find that Excel uses only chr(10) instead of the combination of the chr(13) and chr(10). I have on occasion when moving data back and forth between the Access and excel depending on how its done had to do a search and replace to get the conversion right.

58277

TheSmileyCoder

2,322

Expert Mod 2GB

Expand|Select|Wrap|Line Numbers

vbCrLf = vbNewLine = chr(13) & chr(10)

Sep 18 '12 #2

syedshaffee

TheSmileyCoder You ROck???

Sep 18 '12 #3

TheSmileyCoder

2,322

Expert Mod 2GB

Thank you for those kind? words :)

Sep 18 '12 #4

by: Jason | last post by:

When users fill out my text area field, there is a chance that there will be no line feeds or cariage returns or spaces and just one really long word. THIS CAUSES A MAJOR PROBLEM! What I am trying...

ASP / Active Server Pages

How to combine the LEFT and VbCrLF thingy with a single text fiiled ...

by: Techy | last post by:

I have used thecode which is below to get x characters on to display <%= LEFT(rsName.Fields.Item("columnname").Value,50)%> It works fine but when I use this same code to get x characters plus...

ASP / Active Server Pages

Using the vbCrLf constant

by: Michael.McD | last post by:

Would anyone know how I might access to the vbCrLf constant. I'd like to use teh following bit of VB code in C#: strFoo.Text.Replace(vbCrLf, chr(10) ) Thanks in advance, Michael McD Ps...

C# / C Sharp

Simple question about 'vbCrLf' is not declared

by: Joe | last post by:

Hi, I have a simple form that does nothing but emails the whatever user entered in the form fields. The form is working fine and email sent. The problem I am having is in te string that forms...

ASP.NET

Error removing last vbCrLf character from a text file created by FSO CreateTextFile

by: Andyza | last post by:

I'm using FileSystemObject to open and write to a tab delimited text file. First, I connect to a database and select some data. Then I create the text file and insert each record in the text...

ASP / Active Server Pages

What would cause a windows service to require two starts before starting up?

by: rsine | last post by:

I have created my first windows service and have found that it fails when I initially start it but when I immediately try to restart the service it starts. What could be causing this behavior? I...

.NET Framework

Limiting what shows up in 'Browse' dialogue

by: developing | last post by:

Hello, This time I want to filter the 'browse for file' API so that certain drives/folders cant be accessed. Not sure how to go about this...here is the module I am currently using to browse...

Microsoft Access / VBA

vbCrLf

by: dancer | last post by:

What is this? vbCrLf

ASP.NET

line feeds in Gridview cells? vbcrlf ? new line?

by: wildman | last post by:

Is there any way for gridview cells to observe vbcrlf in the data? I attempted to do this, but it does not seem to work. Dim dgItem As GridViewRow For Each dgItem In gridCollaborator.Rows...

ASP.NET

Working interchangeably with vbCrLf in a TextBox and <br> in a Label

by: Jim in Arizona | last post by:

On one page I have a datalist where a message is bound to a label. On another page I have the datalist which allows for the insert of new message as well as being able to edit those messages. The...

ASP.NET

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

✓ answered by TheSmileyCoder

Similar topics