Hi
I have been reading the recent posts about memo feilds and sizes, missing contect etc, also have researched Google beofre positing here. I can't seem to find what I need to know, well I found half of what i needed.
I have a memo field and a text field in tblContract_Clause which stores a compliance type and a contract clause, the size of the clause field, which is memo type can be anywhere up to 500 characters. I have a form that is called frmNon_Compliance. This form is based on tblNon_Compliances and also has 2 fields called Compliance_Type and Clause. When the user select the compliance type from a drop down box, code will automatically populate the clause field from the tblContract_Clause table. This works fine and I hide the Clause field on the form, as user don't need to see the clause on the form.
I have a report that is based on a query and when that report is called upon, the field Clause only shows 255 characters of the clause.
Can anyone assist me with the best way to show the clause on the report as I don't need it to be visible on the form. But the clause needs to populated from the complaince_Type entered onto the form.
This is the code that populates the clause field on the form from the compliance type selected. Hopefully I have explained my problem correctly. The code is working fine, doing the job. I also just found (just had to come back and edit this post) that the tblNon_Compliance where the clause should be stored is not showing the full clause, only the 255.
I have been reading the recent posts about memo feilds and sizes, missing contect etc, also have researched Google beofre positing here. I can't seem to find what I need to know, well I found half of what i needed.
I have a memo field and a text field in tblContract_Clause which stores a compliance type and a contract clause, the size of the clause field, which is memo type can be anywhere up to 500 characters. I have a form that is called frmNon_Compliance. This form is based on tblNon_Compliances and also has 2 fields called Compliance_Type and Clause. When the user select the compliance type from a drop down box, code will automatically populate the clause field from the tblContract_Clause table. This works fine and I hide the Clause field on the form, as user don't need to see the clause on the form.
I have a report that is based on a query and when that report is called upon, the field Clause only shows 255 characters of the clause.
Can anyone assist me with the best way to show the clause on the report as I don't need it to be visible on the form. But the clause needs to populated from the complaince_Type entered onto the form.
This is the code that populates the clause field on the form from the compliance type selected. Hopefully I have explained my problem correctly. The code is working fine, doing the job. I also just found (just had to come back and edit this post) that the tblNon_Compliance where the clause should be stored is not showing the full clause, only the 255.
Code:
Private Sub ID_Compliance_Type_Combo_Click()
If IsNull(Me.ID_Compliance_Type_Combo) = False Then
Me.Compliance_Type= Me.ID_Compliance_Type_Combo.Column(0)
Me.Clause = Me.ID_Compliance_Type_Combo.Column(1)
End If
End Sub
