True/False or Y/N when copy to Excel

G

Ginola

Hi all,

I have access database with check box field. Previously when I copy &
paste the record to excel, it shows "Y/N". However, I forgot when it
starts pasting "True/False" in Excel. Is there any setting which can
change it back to Y/N ?

thanks
 
S

Sheila D

If you look at the table in design view the Format property lets you change
Yes/No to True/False etc. HTH

Sheila
 
G

Ginola

I have used Yes/No in table design, but somehow it still shows
True/False when I copy & paste to Excel...

Any other idea?
 
S

Sheila D

You could take it to a query 1st and in the query use an IIF statement to
change the output; Newfield: IIf([MyField],"Yes","No") Change Newfield to
whatever you want at the top of the coluymn and Myfield to your field name.

You might find it easier to use the Analyse it with MS Excel button on the
toolbar rather than Copy/Paste. Clcik on the table or query to select it but
do not open then choose the command and will take straight to Excel. HTH

Sheila
 
G

Ginola

I see... sound complicated... actually, I just wonder if there is any
simple way because it does work before doing copy/paste...
I thought it should be some setting which can fix this.

Anyway, thanks for you suggestion.

You could take it to a query 1st and in the query use an IIF statement to
change the output; Newfield: IIf([MyField],"Yes","No") Change Newfield to
whatever you want at the top of the coluymn and Myfield to your field name.

You might find it easier to use the Analyse it with MS Excel button on the
toolbar rather than Copy/Paste. Clcik on the table or query to select it but
do not open then choose the command and will take straight to Excel. HTH

Sheila

Ginola said:
I have used Yes/No in table design, but somehow it still shows
True/False when I copy & paste to Excel...

Any other idea?
Click to expand...
Click to expand...
 
Top