467,077 Members | 1,016 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,077 developers. It's quick & easy.

A lost field

I have belatedly discovered an odd problem. I created a new memo field
called "IntellectualAccessNotes" in a replicated table . I put it into
a form and people have been entering data into it and the data is
showing up in the right places in reports and everything is working
fine. However the field no longer appears in either the design view or
the datasheet view of the table. If I open the forms and reports that
already include the field and view a field list, it is not on the
list.

I finally discovered that it is showing up in the available field list
within the query and form wizards. If I select it in the query wizard
to include in the query and then look at design view, instead of
simply reading as the field name, the query insists on repharasing it
as Expr1:= [IntellectualAccessNotes] and again the field does not show
up in the field list above the query design.

Is there a way to solve this and what is the cause? Should I leave
well enough alone?

I appreciate the help,

Jonathan
Nov 12 '05 #1
  • viewed: 1476
Share:
1 Reply
Jonathan wrote:
I have belatedly discovered an odd problem. I created a new memo field
called "IntellectualAccessNotes" in a replicated table . I put it into
a form and people have been entering data into it and the data is
showing up in the right places in reports and everything is working
fine. However the field no longer appears in either the design view or
the datasheet view of the table. If I open the forms and reports that
already include the field and view a field list, it is not on the
list.

I finally discovered that it is showing up in the available field list
within the query and form wizards. If I select it in the query wizard
to include in the query and then look at design view, instead of
simply reading as the field name, the query insists on repharasing it
as Expr1:= [IntellectualAccessNotes] and again the field does not show
up in the field list above the query design.

Is there a way to solve this and what is the cause? Should I leave
well enough alone?

I appreciate the help,

Jonathan


Have you tried Compact & Repair?

--
MGFoster:::mgf
Oakland, CA (USA)

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by dmcconkey@yahoo.com | last post: by
6 posts views Thread by Ellis Yu | last post: by
7 posts views Thread by Jimmie H. Apsey | last post: by
1 post views Thread by D. Shane Fowlkes | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.