print string by access (1 Viewer)

[24sharon]

I have string

I want to print the string and no by report

for example:

dim s as string

s = "hi" & vbcrlf & vbcrlf
s = s & "my name is sharon"


now I want to print the string in the printer
with default font and default size.

is it possible?

thanks!

 

[ghudson]

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

Print text string to default printer

I had just posted that code a few days ago.

 

[24sharon]

first of all thanks,

and I agree with you that I have to search.

but

english is not my home language so search and find the exectly what you search is not so easy.
think about it.


second
I try your code in my project and it dont work
is it need some change or it have to work just by copy paste?

(access 2003)
thanks

 

[ghudson]

It is possible this will not work if your printer name contains a space.

User this to test the name of your default printer...

MsgBox Printer.DeviceName, , "Default Printer Name"

 

[24sharon]

My printer have space in the name

so I changed the name of the printer without spaces (picture attach)

and its also dont work.

what do I need?

thanks!

 

[ghudson]

I regret that I do not know why it will not work for you. I just opened your attachment and it printed the text string just fine on my printer.

I had the need for the code last week and I searched all of the net until I found what I posted in the sample code section. Try googling and maybe you will have better luck.

 

[24sharon]

Tnx


I will try on other computer.