Hyperlink Field Size - max field size = 255...why?

S

SteveS

Background...
I created a table
I set the filed data type = hyperlink
In the forms section, the filed created references the hyperlink field in
the table

Problem...
When i enter a new field as a hyperlink, it is only saving up to 255
characters. According to MS, "Each part of the three parts of a Hyperlink
data type can contain up to 2048 characters."

Question...
How do I increase the field size so that when I enter a hyperlink, it saves
the entire link after I enter it and does not cut off the link after 255
characters?

Thanks!
 
J

John Vinson

How do I increase the field size so that when I enter a hyperlink, it saves
the entire link after I enter it and does not cut off the link after 255
characters?
Click to expand...

Be sure that you don't have any Format property, sort order, or
grouping on the bound control or the query.

John W. Vinson[MVP]
 
S

SteveS

Format property, sort order, or grouping on the bound control or the query
does not exist...but run me through this to verify - I may have missed
something. This still does not work.

Thanks.
 
Top