RE: [MS_AccessPros] how to show the itinerary horizontally like this: Paris-Tours-Dijon in the unbound text box in the mainForm.

Kevin,

You can use the generic concatenate function found at http://www.tek-tips.com/faqs.cfm?fid=4233 to return the values in one expression.


Duane Hookom, MVP

MS Access

________________________________
> To: ms_access_professionals@yahoogroups.com
> From: MS_Access_Professionals@yahoogroups.com
> Date: Sun, 20 Sep 2015 08:02:54 +0800
> Subject: [MS_AccessPros] how to show the itinerary horizontally like
> this: Paris-Tours-Dijon in the unbound text box in the mainForm.
>
>
>
> Dear All,
>
> I have a subform called "subItinerary" attached to frmMain, in the subform there is list of itinerary like this:
>
> frmMain
> "Itinerary": unbound text box
>
> subfrom: subItinerary
> ItineraryID Date City
> 1 25-Sep-2015 Paris
> 2 26-Sep-2015 Tours
> 3 27-Sep-2015 Dijon
>
> My question is how to show the itinerary horizontally like this: Paris-Tours-Dijon in the above unbound text box. I uploaded the access file to group file 2_AssistanceNeeded. Please help. Thanks in advance.
>
> Best Regards,
> Kevin
>
>
> ________________________________
> Regards,
> Kevin Zhao
>
>
>

------------------------------------

------------------------------------


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/