I am trying to edit the format of a bit field using a query. In design view, the format I want for the field is ";\1;0". When I write a query

ALTER TABLE MASTPLU ADD ALLOWFLAG BIT FORMAT ;\1;0

I get a syntax error in alter table statement.

Can this be done using a query???

Thanks.