Solved Text box length gets cropped in a form (1 Viewer)

[AnilBagga]

I have 2 unbound text boxes in different forms using the same expression to display [FGCode].[column](1). FG code is a column of the same table used in the both forms

In one form the value is displayed as in the table, but in the other form, it gets cropped - see below. What could be the reason. I could not find any property which could be causing this. I tried to delete the text box and added a new text box, no improvement!

Full version

Cropped version

 

[theDBguy]

Do you know if that cut off is at the 255th character?

 

[AnilBagga]

I have the FG specs in table set to long text. But, if the table is same, why is the display different in different forms?

 

[AnilBagga]

I have the FG specs in table set to long text. But, if the table is same, why is the display different in different forms?

Yes. It is 255. The other form is displaying 268

 

[arnelgp]

what is the Controlsource of each textbox?

 

[AnilBagga]

what is the Controlsource of each textbox?

The cropped version text box is unbound. cbo box is FGCode and source of the cbo is the table of ItemMaster. The text box control source is [fgcode].column(1)

The uncropped version is coming from a query, as source of this form is a Query. The cbo in ths form is the same table as above - Item master and the source code of the textbox is the FG specs in the query (tblItemMasterPricingSpecs.FGSpecs). The FG specs in the query however come from the same table as the above mentioned form (ItemMaster)

 

[arnelgp]

don't you think the combo can only accept 255 characters?
see this discussion: Combo Box Length Limit? | Access World Forums (access-programmers.co.uk)

 

[AnilBagga]

don't you think the combo can only accept 255 characters?
see this discussion: Combo Box Length Limit? | Access World Forums (access-programmers.co.uk)

I saw that. What I could understand though as to why it works in the other case!

 

[AnilBagga]

I saw that. What I could understand though as to why it works in the other case!

I put a dlookup statement in the text box and now I can get the full text. Thank you

 

[theDBguy]

I put a dlookup statement in the text box and now I can get the full text. Thank you

Hi. Glad to hear you got it sorted out. Good luck with your project.