CONCATENATE/TRIM WITH WHITE SPACE (RETURN KEY)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have this formula/expression in a query where i want to show a message to
the user. (It doesnt have to be in a query but for this example lets assume
it IS in the query).

So it looks like this:

PassengerMessage: Trim("Dear" & " " & [Title] & " " & [txtPassengerName] &
". Your booking " & [numBookingNumber] & " " & "is confirmed for " &
[dateBookingTime] & ".")

It thus brings up the message like this: Dear Mr R Selshop. Your booking
1234567890 is confirmed for 10:00.

What i want to do though is this:

Dear Mr R Selshop.
Your booking 1234567890 is confirmed for 10:00.

(I want a return key after the fullstop after the Surname)

Can this be done and if so - HOW?!?!

Fanks!!!

Ant
 
PassengerMessage: Trim("Dear" & " " & [Title] & " " & [txtPassengerName] &
". " & Chr(13) & Chr(10) &
"Your booking " & [numBookingNumber] & " is confirmed for " &
[dateBookingTime] & ".")

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Damn! that works!! How'd ya know that?!? :) Cheers!!!

Another prob i have on this same formula is the fact that it displays my
time as 10:00:00 PM instead of 22:00 (i want the latter).

Ive select "Short Date" from the table that it runs from so why is this
happening??

Your assitance would be SOOO appreciated! - Thanks John! (and anyone else
that can help!!)


John Spencer said:
PassengerMessage: Trim("Dear" & " " & [Title] & " " & [txtPassengerName] &
". " & Chr(13) & Chr(10) &
"Your booking " & [numBookingNumber] & " is confirmed for " &
[dateBookingTime] & ".")

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

ant1983 said:
Hi,

I have this formula/expression in a query where i want to show a message
to
the user. (It doesnt have to be in a query but for this example lets
assume
it IS in the query).

So it looks like this:

PassengerMessage: Trim("Dear" & " " & [Title] & " " & [txtPassengerName] &
". Your booking " & [numBookingNumber] & " " & "is confirmed for " &
[dateBookingTime] & ".")

It thus brings up the message like this: Dear Mr R Selshop. Your booking
1234567890 is confirmed for 10:00.

What i want to do though is this:

Dear Mr R Selshop.
Your booking 1234567890 is confirmed for 10:00.

(I want a return key after the fullstop after the Surname)

Can this be done and if so - HOW?!?!

Fanks!!!

Ant
Click to expand...
Click to expand...
 
Try using
Format([DateBookingTime],"hh:mm")

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

ant1983 said:
Damn! that works!! How'd ya know that?!? :) Cheers!!!

Another prob i have on this same formula is the fact that it displays my
time as 10:00:00 PM instead of 22:00 (i want the latter).

Ive select "Short Date" from the table that it runs from so why is this
happening??

Your assitance would be SOOO appreciated! - Thanks John! (and anyone else
that can help!!)


John Spencer said:
PassengerMessage: Trim("Dear" & " " & [Title] & " " & [txtPassengerName]
&
". " & Chr(13) & Chr(10) &
"Your booking " & [numBookingNumber] & " is confirmed for " &
[dateBookingTime] & ".")

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

ant1983 said:
Hi,

I have this formula/expression in a query where i want to show a
message
to
the user. (It doesnt have to be in a query but for this example lets
assume
it IS in the query).

So it looks like this:

PassengerMessage: Trim("Dear" & " " & [Title] & " " &
[txtPassengerName] &
". Your booking " & [numBookingNumber] & " " & "is confirmed for " &
[dateBookingTime] & ".")

It thus brings up the message like this: Dear Mr R Selshop. Your
booking
1234567890 is confirmed for 10:00.

What i want to do though is this:

Dear Mr R Selshop.
Your booking 1234567890 is confirmed for 10:00.

(I want a return key after the fullstop after the Surname)

Can this be done and if so - HOW?!?!

Fanks!!!

Ant
Click to expand...
Click to expand...
Click to expand...
 
Back
Top