ACCESS FEED: Re: [MS_AccessPros] vbCrLf

Rabu, 17 Juli 2013

Re: [MS_AccessPros] vbCrLf

Dear Graham,
Thanks a lot for your quick reply. I am going to try it today.
Best Regards,
Kevin

On 18-Jul-2013 14:54, Graham Mandeno wrote:
>
> Hi Kevin
>
> vbCrLf (and other similar constants) can only be used in VBA code, not in
> query expressions (which include the expressions in calculated controls)
>
> Instead, you must use the Chr() function. vbCrLf consists of two
> characters
> - a "carriage return" (CR) which is Chr(13) and a "line feed" (LF)
> which is
> Chr(10). So you need an expression like this:
>
> =[HotelName] & Chr(13) & Chr(10) & [HotelAddress] & Chr(13) & Chr(10) &
> [HotelPhone]
>
> Best wishes,
> Graham
>
> ------------------------------------------
> Graham Mandeno
> Microsoft Access MVP 1996 - 2013
>
> > From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>] On Behalf Of qingqinga
> > Sent: Thursday, 18 July 2013 6:39 p.m.
> > To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > Subject: [MS_AccessPros] vbCrLf
> >
> >
> > Dear All,
> > I have an unbounded textbox, I wrote something like: "=[HotelName] &
> vbCrLf & [HotelAddress] & vbCrLf & [HotelPhone]", and I am expected to get
> the hotel information as following:
> >
> > HotelName
> > HotelAddress
> > HotelPhone
> >
> > for example:
> > XXX Hotel
> > XXX Road,XXX City, China
> > 0086-12345478
> >
> > My problem is that "vbCrLf" doesn't work as "another line". Please help.
> Thanks.
> >
> > Best Regards,
> > Kevin
>
>

--
Zhao LiQing
Be adventurous, be bold, be careful, be a star !

[Non-text portions of this message have been removed]