You can use vbcrlf vbcr vblf. CR is carriage return LF is line feed so in your
example you would just add + VBCRLF access will automatically upper case that
since its a reserved word.
________________________________
From: Oldtimer <a_gilmour@bigpond.com>
To: AccessVBACentral@yahoogroups.com
Sent: Wed, October 13, 2010 7:49:48 PM
Subject: [Access VBA Central] new line ?
Hi all
Being new to access 2000 I have a question
I have a text box , I want to add info depending the to of message I need to
write
eg text1= fred
If x=1 then text1=text1 + Chr(&H20) + info 1+ new line + more info
How can I add a new line ?
Andrew Gilmour
Noosa Sea Scout
LIC Cub section
[Non-text portions of this message have been removed]
Tecnologia, programação e muito Visual FoxPro.
quinta-feira, 14 de outubro de 2010
Re: [Access VBA Central] new line ?
__._,_.___
.
__,_._,___
Assinar:
Postar comentários (Atom)
Arquivo do blog
-
▼
2010
(3087)
-
▼
outubro
(245)
- Re: ]] XL-mania [[ Membandingkan deretan angka pad...
- ]] XL-mania [[ menjumlah angka puluhan dari satu s...
- Re: ]] XL-mania [[ Membandingkan deretan angka pad...
- ]] XL-mania [[ File - rules_and_tips
- Re: ]] XL-mania [[ Analisis Ulangan Harian Otomati...
- Re: ]] XL-mania [[ Membuat treshold pada chart
- Re: ]] XL-mania [[ Analisis Ulangan Harian Otomati...
- Re: ]] XL-mania [[ Filter berdasarkan huruf besar ...
- Re: [Access VBA Central] Re: Need help with output...
- ]] XL-mania [[ Filter berdasarkan huruf besar / kecil
- Re: ]] XL-mania [[ Filter Excel 2007
- ]] XL-mania [[ Membandingkan deretan angka pada 2 ...
- ]] XL-mania [[ Analisis Ulangan Harian Otomatis te...
- [Access VBA Central] Re: Need help with outputting...
- Re: ]] XL-mania [[ Bantuan untuk Sumproduct
- Re: ]] XL-mania [[ cell berwarna
- Re: ]] XL-mania [[ tangal bulan serta fill otomatis
- RE: ]] XL-mania [[ cell berwarna
- Re: [Access VBA Central] Import SQLite files into ...
- Re: ]] XL-mania [[ cell berwarna
- RE: [Access VBA Central] Import SQLite files into ...
- Re: [Access VBA Central] De Normalizing a Parent C...
- [Access VBA Central] Re: Need help with outputting...
- Re: ]] XL-mania [[ tangal bulan serta fill otomatis
- ]] XL-mania [[ cell berwarna
- Bls: ]] XL-mania [[ ngitung sks bernilai
- RE: ]] XL-mania [[ ngitung sks bernilai
- Re: ]] XL-mania [[ jika fungsi IF tidak mengcover ...
- Re: ]] XL-mania [[ ngitung sks bernilai
- Re: ]] XL-mania [[ ngitung sks bernilai
- Re: ]] XL-mania [[ ngitung sks bernilai
- Re: [Access VBA Central] Import SQLite files into ...
- ]] XL-mania [[ ngitung sks bernilai
- Re: ]] XL-mania [[ Bantuan untuk Sumproduct
- ]] XL-mania [[ Bantuan untuk Sumproduct
- Re: ]] XL-mania [[ Lookup Table
- RE: ]] XL-mania [[ Lookup Table
- Re: ]] XL-mania [[ Mencari character yang sama
- Re: ]] XL-mania [[ Filter Excel 2007
- Bls: ]] XL-mania [[ Lookup Table
- Re: ]] XL-mania [[ jika fungsi IF tidak mengcover ...
- Re: ]] XL-mania [[ Lookup Table
- RE: ]] XL-mania [[ Lookup Table
- Re: ]] XL-mania [[ Mencari character yang sama
- Re: ]] XL-mania [[ Mencari character yang sama
- Re: ]] XL-mania [[ Filter Excel 2007
- Re: ]] XL-mania [[ Lookup Table
- Re: ]] XL-mania [[ Lookup Table
- Re: ]] XL-mania [[ jika fungsi IF tidak mengcover ...
- Re: ]] XL-mania [[ Mencari character yang sama
- Re: ]] XL-mania [[ Lookup Table
- Re: ]] XL-mania [[ Filter Excel 2007
- Re: ]] XL-mania [[ Mengambil nama Depan
- ]] XL-mania [[ jika fungsi IF tidak mengcover semu...
- ]] XL-mania [[ Buat Beberapa Report berdasarkan Da...
- ]] XL-mania [[ Chartspace
- ]] XL-mania [[ Mencari character yang sama
- Re: ]] XL-mania [[ merubah format date menjadi for...
- ]] XL-mania [[ wta cara posting
- ]] XL-mania [[ Lookup Table
- ]] XL-mania [[ Filter Excel 2007
- Re: ]] XL-mania [[ merubah format date menjadi for...
- Re: ]] XL-mania [[ merubah format date menjadi for...
- ]] XL-mania [[ merubah format date menjadi format ...
- Re: ]] XL-mania [[ VBA Code Untuk Remider dan Foll...
- Re: ]] XL-mania [[ VBA Code Untuk Remider dan Foll...
- Re: ]] XL-mania [[ VBA Code Untuk Remider dan Foll...
- Re: ]] XL-mania [[ chart yg blom sempurna...
- Re: ]] XL-mania [[ chart yg blom sempurna...
- ]] XL-mania [[ kolom hilang setelah di consolidated
- ]] XL-mania [[ VBA Code Untuk Remider dan Follow Up
- Re: ]] XL-mania [[ Mengambil nama Depan
- Re: ]] XL-mania [[ Mengambil nama Depan
- Re: ]] XL-mania [[ Mengambil nama Depan
- Re: ]] XL-mania [[ Lookup dg lebih dr 1 kriteria
- ]] XL-mania [[ rincian pemakaian secara automatic
- Re: ]] XL-mania [[ Lookup dg lebih dr 1 kriteria
- ]] XL-mania [[ Mengambil nama Depan
- Re: ]] XL-mania [[ tangal bulan serta fill otomatis
- Re: ]] XL-mania [[ Lookup dg lebih dr 1 kriteria
- ]] XL-mania [[ tangal bulan serta fill otomatis
- Re: ]] XL-mania [[ selisih tanggal dan angka
- ]] XL-mania [[ Lookup dg lebih dr 1 kriteria
- [Access VBA Central] Import SQLite files into Access
- ]] XL-mania [[ Menentukan dead stock
- ]] XL-mania [[ chart yg blom sempurna...
- Re: ]] XL-mania [[ selisih tanggal dan angka
- Re: ]] XL-mania [[ Mail Merge seribu data
- [Access VBA Central] Need help with outputting fro...
- Re: ]] XL-mania [[ selisih tanggal dan angka
- Re: ]] XL-mania [[ selisih tanggal dan angka
- Re: ]] XL-mania [[ selisih tanggal dan angka
- Re: ]] XL-mania [[ error pada excel 2007
- ]] XL-mania [[ selisih tanggal dan angka
- Re: ]] XL-mania [[ nilai MINIMAL tp bukan nol
- Re: ]] XL-mania [[ menyembunyikan baris yang nggak...
- Re: ]] XL-mania [[ Menambah Nomor Halaman
- Re: ]] XL-mania [[ nilai MINIMAL tp bukan nol
- Re: ]] XL-mania [[ pembulatan bukan 0.00
- Re: ]] XL-mania [[ free memory
-
▼
outubro
(245)
Nenhum comentário:
Postar um comentário