MS Access中是否有回车符，换行符常量? [英] Is there Carriage Return, Line Break constant in MS Access?

问题描述

一个简单的问题，我的脑袋...

A simple question, doing my head in...

我有一个大型访问数据库要清理.

I have a large access database to clean up.

在Access中是否有用于换行的系统常量(如VB的VBCrLf)?

Is there a system constant for a line break in Access (Like VB's VBCrLf)?

如果没有，我想我只需要使用Chr(13)+ Chr(10)

If not,I guess I'll just have to use Chr(13) + Chr(10)

推荐答案

在VBA中，vbCrLf是换行常量(以及vbCr和vbLf).

In VBA, vbCrLf is the line break constant (along with vbCr and vbLf).

在字符串数据列中，它是Chr(13) + Chr(10)(这是vbCrLf的定义).

In a string data column, it's Chr(13) + Chr(10) (which is what vbCrLf is defined as).

这篇关于MS Access中是否有回车符，换行符常量?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！