Access forms to Powerpoint

S

Stacy

I have designed access forms to show my data (originally from an excel
spreadsheet) in the look and feel that I want. I have two questoins:
1. Is there a way to get access to recognize line breaks? Right now, I just
get squares showing up everytime it should be a line break
2. Is there a way to export the forms with data into powerpoint slides - so
that each item/page (eg. row of data) is a different slide? This is my
ultimate goal - to have fields auto-populate in the look and feel I want and
then produce a presentation deck from it.
 
D

Douglas J. Steele

1. Access requires both a Carriage Return and a Line Feed (Chr(13) and
Chr(10) respectively, and in that order), whereas Excel only requires a Line
Feed. You can use the Replace function to fix it:

Replace(MyTextField, Chr(10), Chr(13) & Chr(10))

or (if not in a query)

Replace(MyTextField, vbLf, vbCrLf)

2. You can do screen prints, or you can use a screen capture program (I use
SnagIt, from TechSmith)
 
S

Stacy

Thanks. I will try the line return function. I have been using snag it, but
was hoping there was another way so that it was actual text on the slide
instead of images so it can be edited as we present and talk.

Thanks again.
 
D

Douglas J. Steele

While it may be possible to interact with the data through PowerPoint (and
to be honest, I don't think it is), it definitely wouldn't be by inserting
an Access form into the slide.

PowerPoint is really a means of presentation, not a means of interacting
with data.
 
Top