Split Form Datasheet Font Property

Question

I have a filed on a split form that I set Display As Hyperlink to Screen Only. I don't want the field in the datatsheet to be underlined but I can't seem to prevent it form being underline if I have the Display As Hyperlink set to Screen Only. The field in the single form part of the split form I'm able to do it but not in the datasheet. I've used the following in the On Load and On Open of the form: Me.DatasheetFontUnderline = False to no avail.

Is this normal?

James

Answer 1

I thought this blog entry might be a good reference for anyone wanting more information on the Display as Hyperlink property:

http://blogs.office.com/b/microsoft-access/archive/2008/01/09/using-hyperlinks-in-access-display-as-hyperlink-and-is-hyperlink.aspx

Kirk Beller

Microsoft Online Community Support

Answer 2

Hi James,

So much like any other property that you would change in the property sheet of a split form, we would only expect that change to be visible in the single form side.  The datasheet is provided sort of as-is, and isn't intended to reflect formatting changes in the property sheet.  In this case you're talking about the Display as Hyperlink property, but let's say for example, that you're updating the Back Color property of the same text box control to red.  What we would expect to see is that the text box would have a background of red in the single form and no background color change in the subform.

The short answer is that this is behavior we would expect to see.  Sorry James.  That's probably not the answer you were looking for . . .

Kirk Beller

Microsoft Online Community Support

Answer 3

That's what I thought. Makes sense.

Thanks,

James