DataBase - Concatenate form fields and include linefeed

Access 2003 Question.

I want to concatenate some table fields into a single text field in a report.
Basic concatenation works OK but I cannot get linefeeds to work. Every way I
try I just get square boxes and no line feeds.

Will very much appreciate it if I can get either confirmation that it cannot
be done or preferrably how to achieve.

--
Regards,

OssieMac

  OssieMac replied to OssieMac

I feel foolish when I have posted a question and the answer comes to me
later. Just had to get the code the correct way around. Chr(13) & Chr(10). I
had them reversed.

--
Regards,

OssieMac

  OssieMac replied...

That works fine in VBA and I use it myself but when concatenating table
fields into a form or report textbox it is not recognized.

--
Regards,

OssieMac

Roger Jennings on Access / Sharepoint DataBase http: / / www.quepublishing.com / articles / article.aspx?p = 1606238 I was very dismayed is it makes it pretty clear that in-house hosting of your Sharepoint server with Access Services to support browser-based Access apps is something only large companies will be able to afford, because the pricing and licensing for the Enterprise version is very, very steep. The alternative is hosted Sharepoint / Access Services, and the costs do not seem terribly high. It seems to me that the pricing is upside-down. Big enterprises do not want to deploy Access apps in the browser - - they will build their own .NET apps, browser-based or not 2010, it could vastly increase those costs for organizations with legacy hardware). The features of Access 2010 used in conjunction with Sharepoint 2010 seem to me to be most compelling for and small businesses. I do not know if I could sell clients on hosted Sharepoint / Access. I have been able to sell clients on hosted Exchange, and it is been very W. Fenton http: / / www.dfenton.com / contact via website only http: / / www.dfenton.com / DFA / Access Discussions SQL Express (1) SQL Server (1) MySQL (1) Exchange Server (1) Windows Server (1

Access 2010 for software development DataBase Hi, What do I need to use Access 2010 (or perhaps 2007) to port our 2003 application and create an executable (MDE in Access 2003)? Are there any issues with 2010? -paulw Access Discussions SQL Server (1) SharePoint (1) Albert D. Kallal (1) Office 2007 (1) Office 2003 (1) Access 2007 (1) Access 2010 (1) Access 2003 (1) You can use Access 2010 to develop

Data Macros Don't Work With Linked Tables??? DataBase I have an Access 2010 ACCDB with an AfterInsert data macro on a table. Works fine. However, when I end and back end file open, just in case that was an issue. Thanks! Neil Access Discussions Windows SharePoint Services (1) SQL Server (1) Access 2.0 (1) SharePoint (1) Outlook 2007 (1) Access 2010 (1) Access 2003 (1) Outlook (1) I should note that I am using the data macro to call a VBA function (by setting a local macro variable to the result of the function call). So this is not for the web, I did not see a problem with calling a VBA function (and various places I have seen online mentioned workarounds for calling VBA from a

Considerations migrating from Access 97 mdb to Access 2003 (or up)? DataBase What are the things I need to watch for? I know about sheet properties and Sandboxing mode and making sure to run Jet 4.0 SP8 for 2003 but what else should I look for? We're kind of at the end of the road (so it seems) with Access 97. It does not play well with Windows 7 Professional even in XP Mode, the is crashy / unsreponsive at times. I figure moving up to a more 'modern' version of Access can help alleviate some of these problems and allow it to run native in Windows XP mode. So I am all ears for recommendations on migration or ways to get Access 97 to work properly in Win 7. Thanks a bunch. Access Discussions Visual Studio .NET (1) Windows XP (1) Office 2007 (1) Access 2007 (1) Access

2010: Essential Diffs? DataBase Sounds like Access 2010 is something of a different animal from preceding versions. Could anybody generalize the big issues? - - PeteCresswell Access Discussions SQL Server (1) Virtual PC (1) Windows XP (1) Visual Studio 2010 (1) SharePoint (1) Access 2010 (1) Office 2010 (1 Access 2007 (1) One starting point would be to browse Access team's blog. http: / / blogs.msdn.com / access / default.aspx Click on "2010 Intro Series" tag, which is high on the top of big of post do you want? Perhaps the big news is the new version of VBA, or what we call VBA 7. This new version of VBA now has a true pointer data type called longPtr