I've always gotten that too, but ignore it because the users are only interested in changing the data which is on the SQL Server. That error only tells you they can't modify the forms or reports.
a.
Help-help! Me too! It's an ADP database, with the data on SQL server. The ADP is on the network and three users hit it. Two work just fine, but the third lists the stored procedures as "storedproc; 1"
the syntax for combining fields into a new field is:
NewField: Field1 & Field2
for example, if you've got firstname and lastname as two fields and want to combine them into one field:
FullName = FirstName & " " & LastName
-or-
FullName = LastName & ", " & FirstName
a.
i have an idea... check the can shrink/grow properties for the section of the report (group header/footer or details, wherever these fields are printing...
a.
i've got a report that has a text box linking to a memo field that has over 2,000 characters in it, and it displays fine... i've got "can grow" set to yes and "can shrink" set to no. can't think of any other settings that would affect it...
a.
memo lets you enter up to 32k of characters. i've never had much luck with memo type data fields - especially if it's a multi-user db. it tends to corrupt *very* easily...
anyhoo - if the length of the text in that field is mostly below 255 characters, you can change the data type to text...
I've got a table with a structure of:
BuildingID PersonId Value1 Value2 Value3
123 001 564 1 952
123 002 122 36 512
What I need to do is transpose the values thusly:
BuildingId PersonId ValueId ValueValue
123 001 1 564
123 001...
heck, why does microsoft do *anything* the way they do?
so - the data type of the field you're linked to is "memo"... does any data in this field get cut short on the report? if so, how many characters display before the cutoff? is it consistent? do you need the field to be memo?
a.
check the properties of the text box; specifically "Can Shrink" and "Can Grow"... make sure they're set to "Yes" and see if that doesn't help.
a.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.