Text becoming numbers

[Davidyam]

Hi,

I am really new at MS access and I have a problem and was hoping if anyone could help me. When I do a data entry on my table, the text in my table would appear to be a number in my form and vice versa. May I know what I should do to ensure that both my table and form would appear as text and not numbers. By the way, this problem occur when I am using Microsoft access 2007.



Thank You very much.

Regards,
Yam

[John_G]

I'm not sure I understand what your problem is; what is the data type of the field in your table - Text or Numeric? What do you mean when you say the data appears as text and not numbers? It sounds to me as if you are only seeing differnces in justification (left or right) between the form and the table.

Can you supply more information, please?

John

[Davidyam]

Hi,

First of all thanks for replying.
I have created a data entry form which consist of text boxes and combo boxes. This combo boxes are link from another table, for example types of Aircrafts where i can select the different types of aircrafts instead of typing out one by one. This table only has two columns, mainly ID and the different types of aircrafts. However when I look back to my table after entering data from my form, under the Types of aircraft, the ID number shows up instead of the different types of aircrafts which is in text.

So actually what did i do wrong or why is the ID number showing up instead of text.

Thank You very much.

Regards,
Yam

[John_G]

I assume the combo box has two columns - ID Number and Aircraft type, in that order. Look at the properties for the Combo Box control - if you want the aircraft type (column 2), and not the ID, to be in the table field, set the Bound Column property to 2.

This should yield the results you are looking for.

John

[Davidyam]

Hi John,

Thanks so much. This actually solves my first problem.I have another question hope you don't mind.

I have created a Advance search form which consist of multi-fields similar to my table. This form is a split form where it allows me to search in the form header and the bottom table filters out the results that I want. The vba code which pulls out when I search for text and dates are fine, however the combobox is giving me trouble again. Below is the vba code for the combobox which I have entered which is similar to what I have found online.

If Not IsNull(Me.cboreg) Then
strWhere = strWhere & "([Regions] Like ""*" & Me.cboreg & "*"") AND "
End If

When I click my search button, this error shows up and I am not sure where i have done wrong.

Syntax error (missing operator) in query expression '([Type of aircraft] = B747)'.

Thanks in advance.

Regards,
Yam

[June7]

You show code for Region but the error refers to aircraft. That is confusing.

Have you step debugged? Follow the code as it executes. See where code deviates from expected behavior, fix, repeat.

[Davidyam]

Hi John,

Thanks for helping, I have solved my problem with the help from the example from Allen Browne posted online. I really appreciate your help. Thank you once again.

Regards,
Yam