Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Code a line break in MS Access query

Posted on 2009-03-30
3
Medium Priority
?
1,042 Views
Last Modified: 2013-11-28
I am running a SWITCH query on an access table and then using this field in a report.  The data returned needs to be broken into two lines.  Is there a way to make the result set expressed in a two line format by using some sort of a line break...i.e. <br> but for Access.  Here is my current query, the returned data would read on one line "mm/dd/yy (Actual)".  I would like that to be broken into two lines without just using space characters b/c that offsets the center formatting.
Target or Actual: Switch([Actual Delivery Date Value]<>'',[Actual Delivery Date Value] & "(Actual)")

Open in new window

0
Comment
Question by:szadroga
  • 2
3 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 2000 total points
ID: 24018834
Hi szadroga,

Target or Actual: Switch([Actual Delivery Date Value]<>'',[Actual Delivery Date Value] & Chr(13) & Chr(10 & "(Actual)")

In the report format it as centered


Good Luck!

Gary
0
 

Author Comment

by:szadroga
ID: 24018974
works perfectly, thanks!
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24018984
Glad to help :>
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question