I have a "long text" field in a table, on my form is it limiting the number to 255 as if it was a short text field. any ideals
I have a "long text" field in a table, on my form is it limiting the number to 255 as if it was a short text field. any ideals
Check that the field is connected to a memo field.
see if there is any textbox property limiting it.
If the tables are linked then be sure to reFresh the links.
Allen Browne gives a good explanation of why Memo Fields (Long Text) are truncated:
http://allenbrowne.com/ser-63.html
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
i have checked everything , in the table under the field it shows everything if I create a form to display it shows everything but the query that is the data source for the combo box is the problem here is the sql statement for that query
SELECT [Systems Query].TON, [Systems Query].SEER, [Systems Query].STAGE, [Systems Query].[HP Model], [Systems Query].[Furance Model], [Systems Query].COIL, [Systems Query].[Heater Kit Model], [Systems Query].[TXV Model], [Systems Query].TOTAL, [Systems Query].DESCRIPTION, [Systems Query].Information, [Systems Query].FinancedPrice, [Systems Query].CashPrice, [Systems Query].EstPayments, [Systems Query].PAYMENT
FROM [Systems Query];
thanks angie
So the problem is with the query, not the form? The one thing from Allen Browne's list that we can't see here are the query properties, the "Unique" setting in particular, which must be set to No.
It is set to no.
I have a combo box on my form that fills in the text box (proposal) depending on what is selected in the combo box. I have the following on change as a event for the combo box which has the row source of the above
me.propsal = me.equiptment.column(9)
Are you saying that the query works and is the row source for the combobox? See the link above - that WILL truncate.
Not understanding about truncate. I have looked at the link but still not getting it
Is the above query the row source for your combobox? If so, it will truncate.
See the last item in the Issue column in the link.
So,
If you can include a unique key in the [systems query] design, you can use the combobox to get that key. Then use a dlookup based on [systems query] and that key to populate me.proposal.
I have a unique key which is ID. I am still not sure how to do the dlookup
First, modify 'systems query' to include that ID.
Then:
column(x) is whatever column the ID is in. I'm assuming 'Descripton' is the field that you want in me.proposal and that 'equipment' is the name of the combobox.Code:me.proposal = dlookup("Description","[systems query]", "ID = " & me.equipment.column(x)
Where should I put this code. In the combo control after update?
That's the spot