Tab Chr(9) in Query

[shamas21]

Hi

Can anyone help me as im trying to put tabs between charcters in a query and I use Chr(9) for the tab but the tab goes to the end of the text.

SELECT 'Tab-->'+Chr(9)+'<--Tab'

I need the tab to be between the 2 arrows i.e.

Tab-->	<--Tab

Many Thanks

 

[John Big Booty]

Given that the native behaviour of the tab key in a text field is to move the cursor to the next field. I'm not sure that appending Chr(9) into a string will have any effect, perhaps try appending a number of consecutive spaces into the string.

 

[WayneRyan]

Shamas,

Try: SELECT 'Tab-->' & Chr(9) & '<--Tab'

But, remember that Access doesn't do a very good job of "displaying" special characters. Access will put them in there, but not display them ... some tools won't even put the special characters in the output.

Try pasting the query output into something like NotePad.

hth,
Wayne