How to add a " on the end of a textbox value?

[Sketchin]

I am trying to add a quotation mark on the end of my textbox value using this code:
=[BuildResolution] & " " "

It will not work because it thinks I am adding a string. Is there any way to do this? The value displayed in the textbox would look like 0.01"

Thanks

 

[plog]

You missed it by one double quote:

=[BuildResolution] & """"

Try to parse this explanation: You have to double double-quotes when they are inside double quotes.

You could also change your outer double quotes to single quotes:

=[BuildResolution] & '"'

 

[David R]

For some reason plog's version will NOT work directly in a form control source (in Access 2010, at least). You can put it (or the easier to parse FormattedBuildResolution: [BuildResolution] & Chr(34) ) in a query, though, and use that behind your form. I don't know why it makes a difference.

 

[Sketchin]

Ha, I figured it was trivial!

Thanks alot!