Field doesn't show full length of record

[Abbosy]

Hi there community
My form which is based on a table carrying same name doesn't append the full length of the text to one of the fields.
I don't know where the mistake is occuring or indeed I don't know if the error is in the table or in the form.
The form is showing full length of the text but when I look it in the table, it has just one or two bits of the full length.
I need your help in fixing or at least advising about this problem. Many thanks in advance

 

[pr2-eugin]

Hello Abbosy, Welcome to AWF.

To get you the help you need, we need a bit more of information. Start with providing some examples of how the data loss or showing screenshots (Since your post count is less than 10, zip your screenshot)

 

[Abbosy]

Hi Paul

Thanks very much for your swift reply. I really appreciate this.

I've uploaded two attachments, one for the form that is based on the table which I uploaded a screen shot as well.

In the record which has ID Number: 15

and in the "SerialNumber" field, when looking at the form, which is where we enter the record, you can see what we entered. Ideally it should append same record into the table, but when looking at the table you see the record is much shorter.

Thanks again for willing to help Paul

 

[pr2-eugin]

The Serial Number seems to be a ComboBox on the Form, so technically what you see might not be the Data that is actually stored in the table. So to understand this correctly; look at the following properties of the ComboBox by switching to design view.

• Row Source
• Column Count
• Column Widths
• Bound Column
• Control Source

That should give some idea. As normally the ComboBox will hide the ID column and display the second column, when actually the stored item would be Column 1 not what you see which is column 2. If you cannot see anything strange, provide the details (shown above) in your next reply.

 

[Abbosy]

Thanks a lot Paul

I looked at the details and compared them with what's in the table but couldn't see anything strange.
I also designed a query based on the table but didn't work either.
I will try to start from scratch hopefully the issue will be solved.

Thanks a lot for taking the time to help, I'm much obliged and sure will be back to ask for more help.