John
Why put them in one field? All you need to do is stack one textbox on top of another. That way you can refer to them separately should the need arise.
But as Clive mentioned, just set the textbox's ControlSource to:
=FirstPart & Chr(13) & Chr(10) & SecondPart
Bill
--- In MS_Access_Professionals@yahoogroups.com, "jfakes.rm" <jfakes@...> wrote:
>
> Bill, thanks for sending this. Is there a way to put it one field instead of two?
>
> --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@> wrote:
> >
> > John
> >
> > The first piece: Left([MyField],instr([MyField],"/"))
> >
> > Second piece: Mid([MyField],instr([MyField],"/")+1)
> >
> > Regards,
> > Bill Mosca, Founder - MS_Access_Professionals
> > http://www.thatlldoit.com
> > Microsoft Office Access MVP
> > https://mvp.support.microsoft.com/profile/Bill.Mosca
> >
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "jfakes.rm" <jfakes@> wrote:
> > >
> > > I have a feild that a user now wants to split into two different fields in a report. I don't have the option of using two different fields in a table as it is one field.
> > >
> > > For example 12345/67899 needs to look like:
> > > 12345/
> > > 67899
> > >
> > > The lengths of the fields can vary for example I could have 1/3, or 12/123, or 1/ (yes thats a blank or null), and there might not be anything in the field at all.
> > >
> > > In a query, how can I code a hard return after the "/", taking into account that there might not be a fraction (null) in the field.
> > >
> > > Thanks in advance,
> > > John F
> > >
> >
>
Tidak ada komentar:
Posting Komentar