Results 1 to 5 of 5

Removing # Sign in HyperLink Address (On Click) Command Button

  1. #1
    GoliathRulz68 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    7

    Angry Removing # Sign in HyperLink Address (On Click) Command Button

    Ok, I need some help on this one. I know the solution is staring me right in the face but I can't see it.

    I have a command button on a Web Mutli-Record form that is using a "= [Report_URL]" value within the Hyperlink Address property. This all seems to work other than the fact that when the link popups up it has a "#" on either side that basically makes it an invalid address. How do I get rid of the # signs to get the web address popup in the URL when a user clicks on the Command Button that is associated to the row the record is on.

    I did try searching for the answer for about an hour prior to doing this post, but I don't seem to be finding the answer.

    Thanks in advance for your time,

    MDF

  2. #2
    GoliathRulz68 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    7
    Click image for larger version. 

Name:	Bad_Link_Clip.jpg 
Views:	5 
Size:	30.0 KB 
ID:	7177

    This is basically how the cmdButton properties looks:

    Click image for larger version. 

Name:	cmdButton.jpg 
Views:	6 
Size:	108.3 KB 
ID:	7178

  3. #3
    GoliathRulz68 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    7

    Wink Solved Issue

    Basically the field [Report_URL] was a Hyperlink field. I created a text field that was not a hyperlink but did contain the text. This being identified as the field for the Command Button worked.

  4. #4
    GoliathRulz68 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    7
    Nervermind. Now it works in the client but when you post it to SharePoint the link doesn't activate.

    I love how stuff works in the client perfectly and then when you post it up .... Like a simple link Microsoft says .... "Oh, you thought that was supposed to work like that .... We don't think so."

  5. #5
    GoliathRulz68 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    7
    So this issue comes down to the fact that text boxes within a SharePoint web form cannot display or use a string value greater than 255 characters. If someone has another idea of how to display a string in a text box on SharePoint of greater than 255 characters let me know. In the meantime, I figured out if I make the link text relative I cut out 50 characters and can get under the 255 for SharePoint to display / use the link.

    The other issue was that I was creating a "searchable" field that has a combination of two large text fields plus some other text fields. I used a left([string here], 250) and basically that truncated it to under the 255, which allows it to work. The issue is that not all the text is searchable, but at this point I don't care.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. VBA to assign address to Hyperlink
    By jip911 in forum Programming
    Replies: 2
    Last Post: 04-05-2012, 01:49 PM
  2. Replies: 1
    Last Post: 03-15-2012, 04:41 PM
  3. Replies: 4
    Last Post: 07-22-2011, 11:52 AM
  4. Command button click event
    By R_jang in forum Programming
    Replies: 10
    Last Post: 10-29-2010, 09:13 PM
  5. Command button as a Hyperlink
    By Alaska1 in forum Access
    Replies: 3
    Last Post: 10-21-2010, 01:08 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums