I am working on a query that provides data for a chart and I need to right justify the data field so the chart axis labels are right justified. I am using the following text string to force a line break between agent name and their firm name.
Example: AgentName: [AgentLast] & ", " & [AgentFirst] & Chr(13) & Chr(10) & [FirmName]
How can I format this string to be right justified?
Bryan Meek
bmeek@adelphia.net
Example: AgentName: [AgentLast] & ", " & [AgentFirst] & Chr(13) & Chr(10) & [FirmName]
How can I format this string to be right justified?
Bryan Meek
bmeek@adelphia.net