Text Field Missing in Linked Database!

Hello,

I want to create a field called K_HEX, I want to make the dataType TEXT and
I want to set its properties as follows:

DisplayControl: ListBox
Row Source Type: Value List
Row Source: "17
mm";"19mm";"3/4""";"21mm";"13/16""";"22mm";"7/8""";"22.5mm";"N/A"

Allow Multiple Values: YES
Allow Value List Edits: YES


My database is already split, so I am adding my new field to a file called
engData where my split tables lie. I have added plenty of record since I
split the database, but for some reason, it is not allowing me to add a field
that is set with the properties that I have above.

When I go to my database to make changes on form and reports etc, this new
field is not appearing in the table. When I look at the table from this file,
K_HEX size is not showing, but there is a blank spot for it... if I try to
edit it here (which I know I can't do) the field re-appears (probably because
its really in the table).

I am not sure what I going on... Can anyone help me?

Thank you!

--
~Erica~

Try a compact repair.

If that doesn't work, delete the linked table (in the front end, not the
real table in the back end), and link it again via the External Data tab of
the ribbon.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Eka1618" wrote in message
...
Hello,

I want to create a field called K_HEX, I want to make the dataType TEXT
and
I want to set its properties as follows:

DisplayControl: ListBox
Row Source Type: Value List
Row Source: "17
mm";"19mm";"3/4""";"21mm";"13/16""";"22mm";"7/8""";"22.5mm";"N/A"

Allow Multiple Values: YES
Allow Value List Edits: YES


My database is already split, so I am adding my new field to a file called
engData where my split tables lie. I have added plenty of record since I
split the database, but for some reason, it is not allowing me to add a
field
that is set with the properties that I have above.

When I go to my database to make changes on form and reports etc, this new
field is not appearing in the table. When I look at the table from this
file,
K_HEX size is not showing, but there is a blank spot for it... if I try to
edit it here (which I know I can't do) the field re-appears (probably
because
its really in the table).

I am not sure what I going on... Can anyone help me?

Thank you!

--
~Erica~

Allen,

That's a good idea! I already tried compacting, I even Compiled &
Decompiled...

I hope this works!
--
~Erica~


"Allen Browne" wrote:

Try a compact repair.

If that doesn't work, delete the linked table (in the front end, not the
real table in the back end), and link it again via the External Data tab of
the ribbon.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Eka1618" wrote in message
...
Hello,

I want to create a field called K_HEX, I want to make the dataType TEXT
and
I want to set its properties as follows:

DisplayControl: ListBox
Row Source Type: Value List
Row Source: "17
mm";"19mm";"3/4""";"21mm";"13/16""";"22mm";"7/8""";"22.5mm";"N/A"

Allow Multiple Values: YES
Allow Value List Edits: YES


My database is already split, so I am adding my new field to a file called
engData where my split tables lie. I have added plenty of record since I
split the database, but for some reason, it is not allowing me to add a
field
that is set with the properties that I have above.

When I go to my database to make changes on form and reports etc, this new
field is not appearing in the table. When I look at the table from this
file,
K_HEX size is not showing, but there is a blank spot for it... if I try to
edit it here (which I know I can't do) the field re-appears (probably
because
its really in the table).

I am not sure what I going on... Can anyone help me?

Thank you!

--
~Erica~

Allen,

That worked great! Hopefully that is all I needed to do...

Thanks again!

--
~Erica~


"Allen Browne" wrote:

Try a compact repair.

If that doesn't work, delete the linked table (in the front end, not the
real table in the back end), and link it again via the External Data tab of
the ribbon.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Eka1618" wrote in message
...
Hello,

I want to create a field called K_HEX, I want to make the dataType TEXT
and
I want to set its properties as follows:

DisplayControl: ListBox
Row Source Type: Value List
Row Source: "17
mm";"19mm";"3/4""";"21mm";"13/16""";"22mm";"7/8""";"22.5mm";"N/A"

Allow Multiple Values: YES
Allow Value List Edits: YES


My database is already split, so I am adding my new field to a file called
engData where my split tables lie. I have added plenty of record since I
split the database, but for some reason, it is not allowing me to add a
field
that is set with the properties that I have above.

When I go to my database to make changes on form and reports etc, this new
field is not appearing in the table. When I look at the table from this
file,
K_HEX size is not showing, but there is a blank spot for it... if I try to
edit it here (which I know I can't do) the field re-appears (probably
because
its really in the table).

I am not sure what I going on... Can anyone help me?

Thank you!

--
~Erica~