Datagrid to Show Address Format

[sila]

Hi

I have a stored procedure that produces an postal address in the format:

My Street,
My Area,
This Town
MY POSTCODE

However this needs to be out put into a datagrid which doesn't seem to want to show the format in this way. Does anyone have any ideas why this might be?


Cheers
Sila

 

[ca8msm]

What format does it show it in? It may be that you have to manually add carriage returns.

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

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[ca8msm]

Meant to say as an example that you could use the Replace function. e.g.

MyAddress = MyAddress.Replace(",","," & vbCrLf)

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

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.