control vs. field

[Guest]

Hi,

I have a form in which the [control] control is displaying a table field
just fine. The table field is a memo type which contains 350 character for
this particular record and example. However, the table field value is being
cut off in a report I have. but when I look at the table field, all of the
data is there. the report field is showing as follows:

"The organization develops, disseminates, and periodically reviews/updates:
(i) a formal, documented, information system maintenance policy that
addresses purpose, scope, roles, responsibilities, and compliance; and (ii)
formal, documented procedures to "

However, the following is the conplete value in the table field:

"The organization develops, disseminates, and periodically reviews/updates:
(i) a formal, documented, information system maintenance policy that
addresses purpose, scope, roles, responsibilities, and compliance; and (ii)
formal, documented procedures to facilitate the implementation of the
information system maintenance policy and associated system maintenance
controls."

Why is the report control cutting off the rest of the value?

Thanks in advance,
geebee

 

[Dirk Goldgar]

Hi,

I have a form in which the [control] control is displaying a table
field just fine. The table field is a memo type which contains 350
character for this particular record and example. However, the table
field value is being cut off in a report I have. but when I look at
the table field, all of the data is there. the report field is
showing as follows:

"The organization develops, disseminates, and periodically
reviews/updates: (i) a formal, documented, information system
maintenance policy that addresses purpose, scope, roles,
responsibilities, and compliance; and (ii) formal, documented
procedures to "

However, the following is the conplete value in the table field:

"The organization develops, disseminates, and periodically
reviews/updates: (i) a formal, documented, information system
maintenance policy that addresses purpose, scope, roles,
responsibilities, and compliance; and (ii) formal, documented
procedures to facilitate the implementation of the information system
maintenance policy and associated system maintenance controls."

Why is the report control cutting off the rest of the value?

There are several possibilities. If your report's recordsource query
groups on that field, it will be truncated to 255 characters. If you
apply formatting to the field, it will be similarly truncated. I'm not
sure whether just having the report group on the field in the Sorting
and Grouping options is enough to force truncation or not, but it might.

 

[Ron Hinds]

They might also need to set the Can Grow property of the control to Yes.

Hi,

I have a form in which the [control] control is displaying a table
field just fine. The table field is a memo type which contains 350
character for this particular record and example. However, the table
field value is being cut off in a report I have. but when I look at
the table field, all of the data is there. the report field is
showing as follows:

"The organization develops, disseminates, and periodically
reviews/updates: (i) a formal, documented, information system
maintenance policy that addresses purpose, scope, roles,
responsibilities, and compliance; and (ii) formal, documented
procedures to "

However, the following is the conplete value in the table field:

"The organization develops, disseminates, and periodically
reviews/updates: (i) a formal, documented, information system
maintenance policy that addresses purpose, scope, roles,
responsibilities, and compliance; and (ii) formal, documented
procedures to facilitate the implementation of the information system
maintenance policy and associated system maintenance controls."

Why is the report control cutting off the rest of the value?

There are several possibilities. If your report's recordsource query
groups on that field, it will be truncated to 255 characters. If you
apply formatting to the field, it will be similarly truncated. I'm not
sure whether just having the report group on the field in the Sorting
and Grouping options is enough to force truncation or not, but it might.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

They might also need to set the Can Grow property of the control to
Yes.

Could be. The length of the tuncated text looks awfully like a
255-character cutoff, though.

 

[Pat Hartman\(MVP\)]

Also make sure that the control's can shrink and can grow properties are
properly set.

Hi,

I have a form in which the [control] control is displaying a table
field just fine. The table field is a memo type which contains 350
character for this particular record and example. However, the table
field value is being cut off in a report I have. but when I look at
the table field, all of the data is there. the report field is
showing as follows:

"The organization develops, disseminates, and periodically
reviews/updates: (i) a formal, documented, information system
maintenance policy that addresses purpose, scope, roles,
responsibilities, and compliance; and (ii) formal, documented
procedures to "

However, the following is the conplete value in the table field:

"The organization develops, disseminates, and periodically
reviews/updates: (i) a formal, documented, information system
maintenance policy that addresses purpose, scope, roles,
responsibilities, and compliance; and (ii) formal, documented
procedures to facilitate the implementation of the information system
maintenance policy and associated system maintenance controls."

Why is the report control cutting off the rest of the value?

There are several possibilities. If your report's recordsource query
groups on that field, it will be truncated to 255 characters. If you
apply formatting to the field, it will be similarly truncated. I'm not
sure whether just having the report group on the field in the Sorting
and Grouping options is enough to force truncation or not, but it might.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Guest]

They might also need to set the Can Grow property of the control to Yes.

Hi,

I have a form in which the [control] control is displaying a table
field just fine. The table field is a memo type which contains 350
character for this particular record and example. However, the table
field value is being cut off in a report I have. but when I look at
the table field, all of the data is there. the report field is
showing as follows:

"The organization develops, disseminates, and periodically
reviews/updates: (i) a formal, documented, information system
maintenance policy that addresses purpose, scope, roles,
responsibilities, and compliance; and (ii) formal, documented
procedures to "

However, the following is the conplete value in the table field:

"The organization develops, disseminates, and periodically
reviews/updates: (i) a formal, documented, information system
maintenance policy that addresses purpose, scope, roles,
responsibilities, and compliance; and (ii) formal, documented
procedures to facilitate the implementation of the information system
maintenance policy and associated system maintenance controls."

Why is the report control cutting off the rest of the value?

There are several possibilities. If your report's recordsource query
groups on that field, it will be truncated to 255 characters. If you
apply formatting to the field, it will be similarly truncated. I'm not
sure whether just having the report group on the field in the Sorting
and Grouping options is enough to force truncation or not, but it might.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)