I have a field on my table defined as a Hyperlink. I want to enter the text with part of it in Quotes. For example, I want the Text to Display in the field to look like this:

"This data in Quotes" followed by this data not in quotes

How can I entere the quotes and not have it chop off the text after the closing quote?

Hi,

What version of Access are you using? Please remember to select the version number when posting questions in case it becomes relevant to the discussion.

Try doubling up the quotes. For example:


Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

Thank you, theDBguy,

I hit the submit now too quickly, but I am using Access 2007.

When I enter your code, it looks like this:
"""This data in Quotes"" followed by this data not in quotes"

I want it to look like this, if possible:
"This data in Quotes" followed by this data not in quotes

Did I misunderstand your suggestive code?

Hi,

Are you saying you were entering the text in the field itself? Then, maybe just try doubling up any quotes you use. For example:

""This data in Quotes"" followed by this data not in quotes

I originally thought you were using code to enter the data.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

I admit, this should not be so difficult.

I promise that when I enter this, and save the record:
""This data in Quotes"" followed by this data not in quotes

The data in the record is saved with
""

Only the double quotes are in the field even though I entered the entire suggestion above.

It must be me.

Hi,


Not necessarily... I failed to mention that I really don't use Hyperlink fields.

Can you post exactly what you are typing in the hyperlink field? I fail to understand where your sample data would hyperlink to. Maybe if I see the actual data, the "light" might turn on for me.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

As you suggested, I have uploaded the Edit Hyperlink prompt, shown as I would like to "see" the data when shown on a form or report. What is shown will actually truncate the text to the left of the right quote, if it is saved this way in the record.

Thanks for your attempts to help me.

Hi,

Thanks for posting the image. The only safe way I have found to keep the quotes where you want them in the display text is to enclose the whole link in parens or brackets (or any other character except quotes). For example:

("Cuban Sandwich" Casserole)

OR

["Cuban Sandwich" Casserole]

Not sure if you're okay with that.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

EDIT: As I perform some more tests, I found out that all you really need is a non-quote and non-space character at the beginning of your link. For example, this will also be a valid display text:

_"Cuban Sandwich" Casserole

Maybe that might look better for you?

This post has been edited by theDBguy: Mar 28 2012, 02:33 PM

I appreciate all of you comments and suggestions, but I'm frankly amazed that there isn't some way to allow the intended text to display correctly. I expected a double quote, or some similar technique, but apparently the desired text can't display.

Again, thanks for all the suggestions. I'll implement one of them.

Hi,

(IMG:style_emoticons/default/yw.gif)

Sorry I couldn't give you a better answer. I just don't have that much experience with Hyperlink fields.

Hopefully, somebody else will jump in with a better answer.

Good luck with your project.